I have following query:
SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
(accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
phone_office asc LIMIT 620300,20
In your opinion, what group of indexes should i use to gain maximum
performance out of this query?
Table users
========
index_id: id
Table accounts
==========
index_id: assigned_user_id, deleted
index_phone: phone_office
After that, do an EXPLAIN in the query.
I´m not sure about index_phone will help you.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]