Re: when to use Indexes

From: "Sebastian" > i have a table with several thousand records. i want to know if adding > an index will improve things, example: > > - > | id | item | text | runtime | dateline > - > > now say i create this query: > > $stats

Re: when to use Indexes

Hello. This is a good start point: http://dev.mysql.com/doc/mysql/en/mysql-optimization.html Sebastian <[EMAIL PROTECTED]> wrote: > i have a table with several thousand records. i want to know if adding > an index will improve things, example: > > --

Re: when to use Indexes

Sebastian wrote: i have a table with several thousand records. i want to know if adding an index will improve things, example: - | id | item | text | runtime | dateline - now say i create this query: $stats = mysql_query(

when to use Indexes

i have a table with several thousand records. i want to know if adding an index will improve things, example: - | id | item | text | runtime | dateline - now say i create this query: $stats = mysql_query(" SELECT COUNT(*)