Q about indices
| From: | sharmad at goatelecom dot com | Date: | Tue, 11 Dec 2001 03:51:08 +0000 |
| Subject: | Q about indices | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14924@lists.php.net to get a copy of this message | ||
Hi,
Having to manny indices to a table,does it effect the performance of a table.Like
a table having following structure
Name :
First name,
Second Name,
Third name,
Age,
Address.
Is it good here to have multiple indices like on only first name, only second
name,only third name and all other combination of first ,second and third name
or the performance increases when we have only 1 indice of all first ,second
and third name
Thanks
-Sharmad