Re: help with picking the right index(s)

Hi Justin, I'm after a little help/advice with indexing... I have a table for measuring hits on each page within a site: year month page hits basically, my php script looks for a row matching this year (2002), this month (12) and this page (something.php). if it finds it, increment by 1,

Re: help with picking the right index(s)

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

help with picking the right index(s)

Hi All, I'm after a little help/advice with indexing... I have a table for measuring hits on each page within a site: year month page hits basically, my php script looks for a row matching this year (2002), this month (12) and this page (something.php). if it finds it, increment by 1,