Data Scrambled after migration from 6.5 - 7.0

[gussifinknottle]

I have a table which has got a clustered index. When I move it from version 6.5 to 7.0, I am unable to see the physical ordering of data, based on the field on which I have the Index, when I do a Simple select.

Why is this happening?

 

[tlbroadbent]

From Knowledgebase article Q195760.

http://support.microsoft.com/support/kb/articles/q195/7/60.asp

"If there is no ORDER BY clause in the query, the query processor is free to decide the cheapest execution strategy. This can be either a logical order scan of the index, or a physical order scan of the index. The latter case may return rows out of order for the index. If ordering is required, use the ORDER BY clause."

Terry

X-) "I don't have a solution, but I admire your problem."