hi all,
i wanted to know how best i could create indexes on a given table.
My database is not normalised, so i have a huge transaction table that i
used to generate my reports.
The thing is that there are at least 5 fields that i can use as indexes in
my queries, to speed them up.
Do you think it's best to have something like:
alter table table_name add key main(field1,field2,field3);
or to have individual indexes like these:
alter table table_name add key main1(field1);
alter table table_name add key main2(field2);
alter table table_name add key main3(field3);
Which of the two can give me the most efficiency??
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
