>If I have a create index syntax starting like this:
>
>
> CREATE Clustered INDEX [Combo1] ON [Dispatch] ([NoEntity])
>
>
>We can see that the list of fields do not have the ASC clause. The next one has:
>
>
> CREATE Clustered INDEX [Combo1] ON [Dispatch] ([NoEntity] ASC)
>
>
>When the ASC clause is not there, does this mean the default is ASC?
Yes.
If it's not broken, fix it until it is.
My Blog