An idx will be used for optimization. However, the disadvantages when compared to cdx, far favor the cdx.


>hi,
>Thanx for the reply.
>So u mean to say that sql doesnt use idx for its optimisation?? or if u have a idx can it be used for optimisation. if so how ??
>
>Please clear these I am very very confused ....
>
>suhashegde