Posted by endlesstide on 04/11/06 21:15

How precisely does this work? Do I have to keep the index managed? I
applied the index to the value I want, and can see it's tacked on in
addition to my primary key. Do I need to modify my SELECT query or do
anything else? Even with this added index, my results are still the
same. Thanks much for helping me with my learning curve.

Recapping my requirements: Assuming I had 10,000 records - I want to be
able to run SELECT * FROM table WHERE id BETWEEN 250 AND 300, and sort
those by columnname 'specialvalue'. I want to see those records as if
I sorted the entire 10,000 reocrd list and snipped out 50 records for
analysis. :) What extra steps do I need to do, to accomplish this feat?

[Back to original message]