On Tue, 03 Dec 2002 12:47:28 +1100, Justin French wrote:
>my php script looks for a row matching this year (2002), this
>month (12) and this page (something.php)
It would seem like one index on year/month/page would be
appropriate then. It could be used for both lookups and for reporting
(a query for 2002/12/* would still use this index).
- Steve Yates
- Detour: The roughest distance between two points.
~ Taglines by Taglinator - www.srtware.com ~
---------------------------------------------------------------------
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
