----- Original Message -----
From: "muruganandam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 4:04 PM
Subject: selection from multiple tables;
>
> for a particular query i have to select data from five tables.
> can any one suggest me a best way to do that in terms of performace..
>
> thanks in advance
>
> muruganandam
Make sure that all the tables have an index and do the selection using the
indexes.
chuck
---------------------------------------------------------------------
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
