MySQL Forums
Forum List  »  Optimizer & Parser

Re: indices not used
Posted by: Rick James
Date: June 21, 2010 06:25PM

Q1:
const,const -- implies it is using only c1 and c2. Strange. Please show me what this says:
SHOW CREATE TABLE products;
(If you are in some UI, you can paste that into the screen that lets you type SQL.)

Maybe c2 is NULLable?

For the query shown, the ALTER I gave you won't do any good. It would be better to do
ALTER TABLE product ORDER BY c1, c2, c3, factor;

Q2:
Let me know if there is a diff between disabling keys and not.

I would not bother running the alter more than weekly unless there is a lot of churn.

Options: ReplyQuote


Subject
Views
Written By
Posted
2766
May 25, 2010 04:13AM
1591
May 25, 2010 12:07PM
1488
May 27, 2010 08:35PM
1432
June 19, 2010 03:35AM
Re: indices not used
1395
June 21, 2010 06:25PM
1336
June 22, 2010 01:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.