General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Dan-
>>
>>I see Alex and Sergey's posts and your replies. I don't see where you posted the results of SYS(3054,1), which is the first thing I'd check when optimizing a SQL-Select just because otherwise I'm not confident of what Rushmore is doing.
>>
>>I don't know what your situation is, but I recently improved a situation by taking off the !DELETED() filter off the PK index, and removed the DELETED() tag. Selects went from seconds to sub second.
>
>The results are Full Optimization. I removed the all the offensive indexes that returns the majority of the records.
I gather you mean you did this and the times are still slow? Are you running these queries locally or over a LAN?
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