There's no reason to use IDX indexes whatsoever. For permanent indexes you should use compound structural index (CDX ). The compound structural index is opened automatically when table is open so you don't have to worry about it getting out of sync with data. The compound non-structural index are used for temporary indexes, if you ever need such.
The bottom line, use compound structural indexes.
Create table foo (f1 c(20),f2 D)
index on f1 tag f1
index on f2 tag f2
Select * from foo where f1 = padr('asd',20) into .....
>
>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.???
>
>
--sb--