>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 ....

Yes, IDX indexes could be used for optimization but sthey have to be explicitly open otherwise VFP wouldn't even know that they exist.