General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only