List:General Discussion« Previous MessageNext Message »
From:Steve Yates Date:December 3 2002 8:36pm
Subject:Re: help with picking the right index(s)
View as plain text  
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 ~
Thread
• help with picking the right index(s)Justin French3 Dec
  • Re: help with picking the right index(s)DL Neil3 Dec
• Re: help with picking the right index(s)Steve Yates3 Dec