RE: indexes and speeds

2008-05-22 Thread Rolando Edwards
L PROTECTED] Sent: Wednesday, May 21, 2008 5:55 PM To: mysql@lists.mysql.com Subject: indexes and speeds hi all... just wondering what is the performance difference between: PRIMARY KEY [/|index_type|/] (/|index_col_name|/1,/|index_col_name|/2) at the time of the table creation or create ind

indexes and speeds

2008-05-21 Thread kalin m
hi all... just wondering what is the performance difference between: PRIMARY KEY [/|index_type|/] (/|index_col_name|/1,/|index_col_name|/2) at the time of the table creation or create index index_name1 on table_name (/|index_col_name|/1); create index index_name2 on table_name (/|index_co