General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Thre's no way you can speed it up w/o packing the table. Even SEEK would take forever.
Yeah, it is supposed to be packed every night, but that (obviously) has been failing.
Thanks
Kev
>>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
Previous
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