General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Have tried all those thing. As Sergey said, packing the table is the only feasible option.
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
>
>1. Be sure to have NOT DELETED() (in the FOR clause)
>2. Select that index (!)
>3. Have SET DELETED ON
>
>But I guess that's all obvious (?)
>
>4. Begin the SCAN with a SEEK (may differ)
>5. Have a WHILE in the SCAN (shouldn't differ opposed to the deleted records).
Previous
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