MySQL :: Re: How to optimize an ORDER BY query using a range to avoid any filesorts

New Topic

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

Posted by: Faury Rodriguez
Date: October 15, 2007 03:44AM

Explain results:
id: 1
select_type: SIMPLE
table: series_main
type: index
possible_keys: NULL
key: weight_db
key_len: 4
ref: NULL
rows: 2874243
Extra: Using where

It just downgrades to an index scan of the entire table and disregards the db portion of the index.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

How to optimize an ORDER BY query using a range to avoid any filesorts

12695

Faury Rodriguez

October 14, 2007 12:57PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

7498

KimSeong Loh

October 14, 2007 05:44PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

5322

Faury Rodriguez

October 14, 2007 11:21PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

5113

KimSeong Loh

October 15, 2007 02:18AM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4879

Faury Rodriguez

October 15, 2007 03:44AM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4709

KimSeong Loh

October 15, 2007 04:22PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4685

Faury Rodriguez

October 24, 2007 02:27PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4522

KimSeong Loh

October 24, 2007 04:35PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

3969

sukh gill

March 28, 2008 10:57PM

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.