Skip to Content
0
Former Member
Nov 06, 2015 at 03:11 PM

Table SCAN on Clustered Index Table

42 Views

Bonjour,

I have been asked by developpers a question that I could not answer and I have been looking around for the answer but to no avail so far.

Considering that a table with a clustered index is physicaly in order on the disk, does a table scan should not return data ordered by the said index (it currently does not)?

select * from mytable

go

A

A

A

B

B

C

E

G

???

Thanks for your time and expertise on this!

Regards, William