Posted by Simon Hayes on 09/26/05 18:17

It would be useful if you posted CREATE TABLE and CREATE INDEX
statements to show exactly what you're doing - is the first column a
character data type? What does the data look like in both columns? Does
your query include an ORDER BY?

Assuming that your goal is to return data in a certain order, then you
can't do it by using a clustered index - the only way is to use ORDER
BY in your queries.

Simon

[Back to original message]