Re: Another basic question - index()

Etienne Marcotte wrote: > What is the exact difference between > this > index(col1,col2). Create a single index on col1 and col2. > > that > index(col1),index(col2). Creat two indexes, one on col1, one on col2. > > and this > index(col1),index(col2),index(col1,col2). Do all three. Note that

RE: Another basic question - index()

> > What is the exact difference between > this > index(col1,col2). > that > index(col1),index(col2). > and this > index(col1),index(col2),index(col1,col2). > > I read in the manual about it, but it's not really clear about the way > to should be used / created. > > Any sql pseudo-teacher in h

Another basic question - index()

What is the exact difference between this index(col1,col2). that index(col1),index(col2). and this index(col1),index(col2),index(col1,col2). I read in the manual about it, but it's not really clear about the way to should be used / created. Any sql pseudo-teacher in here? :) Thanks a lot, Eti