MySQL :: Re: MySQL 5.1.31 -- Same query scans widely different # of rows

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

Posted by: Jørgen Løland
Date: April 09, 2011 06:35AM

> A compound index with these two fields might be best for the second SELECT:
> and listingdis2_.DISPLAY_STAT_REAS_ID=2
> and listings1_.LINE_OF_BUSINESS_ID=11

A compound index covering columns from two different tables?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

MySQL 5.1.31 -- Same query scans widely different # of rows

4165

Blake Harps

April 07, 2011 02:54PM

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

1852

Jørgen Løland

April 08, 2011 08:04AM

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

1465

Blake Harps

April 08, 2011 10:45AM

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

1345

Rick James

April 08, 2011 09:57PM

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

1528

Jørgen Løland

April 09, 2011 06:35AM

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

1468

Rick James

April 09, 2011 01:13PM

Re: MySQL 5.1.31 -- Same query scans widely different # of rows

1430

Jørgen Løland

April 11, 2011 01:23AM

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.