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