MySQL :: Re: MySQL 5.1 does not seem to be using the index that I expect it to.

New Topic

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

Posted by: Rick James
Date: April 02, 2011 11:56AM

What version of MySQL?

`status` int(11) DEFAULT NULL,
-->
`status` TINYINT DEFAULT NOT NULL,

And, if recipient_id is never NULL, make it NOT NULL.
(Ditto for other fields.)

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

MySQL 5.1 does not seem to be using the index that I expect it to.

3433

Tom Muldoon

April 01, 2011 09:34AM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1327

Rick James

April 02, 2011 11:56AM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1414

Tom Muldoon

April 03, 2011 07:46AM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1258

Rick James

April 03, 2011 05:01PM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1255

Tom Muldoon

April 03, 2011 05:40PM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1197

Rick James

April 03, 2011 06:42PM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1301

Tom Muldoon

April 03, 2011 08:11PM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1636

Rick James

April 04, 2011 10:02PM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1348

Tom Muldoon

April 05, 2011 05:07AM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1354

Tom Muldoon

April 05, 2011 02:22PM

Re: MySQL 5.1 does not seem to be using the index that I expect it to.

1383

Rick James

April 05, 2011 09:34PM

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

This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.