hi all,

Can u please tell me where to use what? I am getting it a lot confused.

1) Does the Use command atomatically open the .idx ?? or does it have to be set implesetly i.e. with the set index to command ??

2) If the set index command is used then is the automatically opened cdx is thrown in the dustbin ??

3) DOes the sQL statements use the .idx formed ??

suppose

Create table foo (f1 c(20),f2 D)

index on f1 tag f1
index on f2 tag f2

index on f1 to idxf1
index on f2 to idxf2

use

And then

Select * from foo where f1 = padr('asd',20) into .....

does that use the cdx or idx.

If no cdx is present and only idx is present does the sql use it ??

How should i go about this.???


suhashegde

or