Hi gang:
In a simple purchase table that contains only the customer-id and
purchased item-id would it be better to have an index of not?
In other words, is a Purchase Table
Customer_ID | Item_ID
improved by adding an index (ID)
ID | Customer_ID | Item_ID
or not?
Thanks,
tedd
--
-------
http://sperling.com/
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
