note 3537 deleted from mysql_db_query by danbeck
| From: | danbeck@php.net | Date: | Thu, 07 Sep 2000 15:29:25 +0000 |
| Subject: | note 3537 deleted from mysql_db_query by danbeck | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-4364@lists.php.net to get a copy of this message | ||
re: PHP not using the index:
An SQL index will NOT be used if the query sent is trying to use more columns than the index..
Lets say you have 'col1' indexed, and your query is "select * from mytable where
col1='abc';
Compare that to the mysql LOG for the query done by PHP. I bet that PHP is adding another column for
"bookkeeping" purposes.