|
|
Posted by Surfer! on 04/11/06 23:17
In message <1144779332.929336.198300@v46g2000cwv.googlegroups.com>,
endlesstide@gmail.com writes
>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?
Learn more about SQL?
>
--
Surfer!
Email to: ramwater at uk2 dot net
Navigation:
[Reply to this message]
|