>Hi,
>
>I have a table with a about 40,000 - 50,000 records, with key field SLNO in order, is there any quicker way of finding out any missings nos in between , other than running a scan on the table and comparing with the counter.
Check this recent thread
Select command to highlight missing Numbers Thread #
1311939
If it's not broken, fix it until it is.
My Blog