Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku
My account: Login | Sign Up
Loading... 

'Order by' clause not using indexes | Thread profile

Thread profile page for "'Order by' clause not using indexes" on http://www.mysql.com. This report page is a snippet summary view from a single thread "'Order by' clause not using indexes", located on the Message Board at http://www.mysql.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below. Additional thread profile information is also shown in the following ways:

1) Top Contributing Authors
2) Related Threads on "eBay Auctions"
3) Related Threads on Other Sites

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period.
Title: 'Order by' clause not using indexes
Site: MySQL AB - MySQL Forums  MySQL AB - MySQL Forums - site profile
Forum: General   General - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: mysql.com

Thread posts in 'Order by' clause not using indexes:

1. 
Started 4 years, 5 months ago (2005-01-16 04:33:00)  by marius hagiu
how can i make 'order by' use an index? i have the following table:sales with columns id int(4), suma bigint(12), type char(11) and data date with indexes on (id,type) and (suma) im issuing the following statement: select * from vanzari order by suma but it doesnt use the index if i use explain i get type=ALL and using filesort i also tried 'force index' syntax - still the same ...
Size: 523 bytes
Customize:  Customize "'Order by' clause not using indexes :: General :: MySQL AB - MySQL Forums"
2. 
Started 4 years, 5 months ago (2005-01-17 08:22:00)  by Jonathan Cochran
MySQL will not always use the index if your query is grabbing more than 30% (this # varies) of the total data. I am not positive, but this looks like what is happening in your case. Try using a where clause (WHERE suma = ____ ORDER BY suma), then look at your explain and it should be using the suma index. See this link for a better explanation. [ forums.mysql.com ]
Size: 482 bytes
Customize:  Customize "<b>Reply 1</b>: Re: 'Order by' clause not using indexes :: General :: MySQL AB - MySQL Forums"
 

Top contributing authors for 'Order by' clause not using indexes

Name
Posts
marius hagiu
1
user's latest post:
'Order by' clause not...
Published (2005-01-16 04:33:00)
how can i make 'order by' use an index? i have the following table:sales with columns id int(4), suma bigint(12), type char(11) and data date with indexes on (id,type) and (suma) im issuing the following statement: select * from vanzari order by suma but it doesnt use the index if i use explain i get type=ALL and using filesort i also tried 'force index' syntax - still the same results what indexes from the above table can...
Jonathan Cochran
1
user's latest post:
Re: 'Order by' clause...
Published (2005-01-17 08:22:00)
MySQL will not always use the index if your query is grabbing more than 30% (this # varies) of the total data. I am not positive, but this looks like what is happening in your case. Try using a where clause (WHERE suma = ____ ORDER BY suma), then look at your explain and it should be using the suma index. See this link for a better explanation. [ forums.mysql.com ]

Log-queries-not-using-indexes and "Using index" in the...  MySQL AB - MySQL Forums - site profile Optimizer - forum profile Log-queries-not-using-indexes and
Log-queries-not-using-indexes and "Using index" in the Extra col of Explain
Problem using indexes in innodb table type  MySQL AB - MySQL Forums - site profile InnoDB - forum profile Problem using indexes in innodb table type
Problem using indexes in innodb table type
Query isn't using indexes  MySQL AB - MySQL Forums - site profile Newbie - forum profile Query isn't using indexes
Query isn't using indexes
Large range query stops using indexes  MySQL AB - MySQL Forums - site profile Optimizer - forum profile Large range query stops using indexes
Large range query stops using indexes
Log Query not using indexes  MySQL AB - MySQL Forums - site profile Optimizer - forum profile Log Query not using indexes
Log Query not using indexes
Select query not using indexes  MySQL AB - MySQL Forums - site profile Performance - forum profile Select query not using indexes
Select query not using indexes
WHERE clause using variables  MySQL AB - MySQL Forums - site profile Newbie - forum profile WHERE clause using variables
WHERE clause using variables
Why order clause take more time with index descendent?  MySQL AB - MySQL Forums - site profile Newbie - forum profile Why order clause take more time with index descendent?
Why order clause take more time with index descendent?
Getting a blob result with order clause  MySQL AB - MySQL Forums - site profile Newbie - forum profile Getting a blob result with order clause
Getting a blob result with order clause
"Unknown column 'position' in 'order clause'  MySQL AB - MySQL Forums - site profile Stored Procedures - forum profile
"Unknown column 'position' in 'order clause'
Order by clause using -----sort key------ and passing...  developerWorks : IBM Systems Forums - site profile DB2 for z/OS forum - forum profile Order by clause using -----sort key------ and passing sort key as integer
Order by clause using -----sort key------ and passing sort key as integer
Query result order when using IN clause  dBforums - Database Support Community - site profile MySQL - forum profile Query result order when using IN clause
Query result order when using IN clause
Order By clause using Parameters - MSDN Forums  MSDN Forums - site profile SQL Server Reporting Services - forum profile Order By clause using Parameters - MSDN Forums
Order By clause using Parameters - MSDN Forums
Order by clause using decode function  www.oracle.com - site profile BI Publisher - forum profile Order by clause using decode function
Order by clause using decode function
Contains clause using Criteria  Hibernate Forums - site profile Hibernate Users - forum profile Contains clause using Criteria
Contains clause using Criteria
Blog: log-queries-not-using-indexes...  Twitter / dev0000 - site profile dev0000 - forum profile Blog: log-queries-not-using-indexes http://www.developer0000.jp... [wp2t] 08:57 AM April 02, 2008 from web
Blog: log-queries-not-using-indexes http://www.developer0000.jp... [wp2t] 08:57 AM April 02, 2008 from web
Query takes 5 min when using Indexes and 1 Second without...  www.oracle.com - site profile SQL and PL/SQL - forum profile Query takes 5 min when using Indexes and 1 Second without Indexes !!
Query takes 5 min when using Indexes and 1 Second without Indexes !!
MySql Question --log-queries-not-using-indexes?  MySpacePros - site profile Web Developer Help - forum profile MySql Question --log-queries-not-using-indexes?
MySql Question --log-queries-not-using-indexes?
Community - how do you perform a conditional clause using...  Salesforce.com Community - site profile Apex Code Development - forum profile Community - how do you perform a conditional clause using a record type? - Apex Code Development - Salesforce.com Community
Community - how do you perform a conditional clause using a record type? - Apex Code Development - Salesforce.com Community
Using indexes  Archivaty.net - site profile comp.databases.oracle.server - forum profile Using indexes
Using indexes