General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi
I have a table that contains 192,216 records, 177,493 of these are deleted records.
I have a DELETED() Index on the table, yet when I run a command like SCAN FOR...ENDSCAN on an indexed field, it takes absolutely ages. This is over a 1MB WAN by the way, but it still should only take seconds, it takes minutes, about 3 to be exact.
What am I doing wrong here?
Thanks
Kev
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