-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
thanks, somehow I wasn't able to find those pages. Basically, this means if I've a table like this id1 id2 id3 id4 id5 and I've two different select statements: select * from ... where id1 = .. and id2 = .. and the other being select * from ... where id3 = .. and id4 = .. I would create two indexes, one for id1/id2 and the other for id3/id4 , right? again, thanks - - Markus Косов Евгений wrote: > Hi, Mark! > > Of course, it depends on queries you are running. > > I beleive you can find all anwers here: > http://dev.mysql.com/doc/refman/5.0/en/indexes.html > http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html > http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html > > > Markus Fischer пишет: > Hi, > > is there, performance wise, any difference whether I create one index > for multiple fields or each field with its own index? I'm running 4.0.16. > > thx, > - Markus > >> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEGo1p1nS0RcInK9ARAjOsAJsGmgh1VVI3RCG1ci7sr2vBKR7VgQCgpvg8 k3wTpe1bqh7BIHaDGze+ttY= =ZqNR -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
