General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Are we talking a different network server? Could you be seeing a difference in network response time? Did you add any indices to the .cdx on your personal copy?
>
Thanks for your reply. No on both accounts, it's all on one NT server...there is an addition though...I was checking it out, and while everything is still slower, I noticed that a SELECT on a description doesn't take near as long as a SELECT on a part number...it turns out that there are 2 indexes in the main database for the part number, one is descending, based on part number alone, the other is ascending based on UPPER(partno). Could that compound the difference? Is there a way I can make sure that my SELECT statement will use the ascending index? Is this a valid concern? ...the quest continues;)
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