General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Missing nos in a table where index is in sequence
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only