Its my understanding that creating a clustered index on a table sorts that table (by whatever column the clustered index refers to) physically on the disc (as opposed to non-clustered index).
I have done this and this is the first time i have bothered to look at the column I put the clustered index on and upon doing a select * on the table, it doesn't appear to sort by the clustered column.
Also, just as a lark, i created another table including an ordered by a particular column in creating the table (created from another populated table). When i looked at the results using Select * (with no order by), the records were not sorted by the order i had put in the table creation.
Was wondering why this is? Clearly without an order by, select * has an homunculus in it that decides what it wants the order to be..! Was thinking at least in the case of the clustered index, the retrieval would be off the physical disc and so expected the order by to be per the clustered column.
And it seems the order by in the creation of a table is a complete waste of time?
Thanks for any conceptual help here..