filesort_开发者

MYSQL using filesort when ORDER BY indexed column in simple query

I\'ve seen a lot of similar questions, but I\'m not seeing a solution that will work for me. Or maybe I\'m just being dense. :) Hopefully someone can help me out.[详细]

2023-04-01 02:16 分类：问答

How to avoid filesort for this mysql query

I need some help in avoiding filesort for this query. SELECT id FROM articles USE INDEX(group开发者_如何学Python)[详细]

2023-03-19 19:28 分类：问答

MySQL not using indexes; using filesort

开发者_JS百科MySQL appears to be not using indexes and is using filesort on the following query:[详细]

2023-03-17 01:37 分类：问答

MySQL Join Optimisation: Improving join type with derived tables and GROUP BY

I am trying to improve a query which does the following: For every job, add up all the costs, add up the invoiced amount, and calculate a profit/loss. The costs come from several different tables, e.[详细]

2023-03-14 04:12 分类：问答

Optimize slow MySQL query to remove Using where; Using temporary; Using filesort

I\'m trying to optimize a query which is taking over 2 seconds to return a response against a database of only 10,000 records.Explain shows it should return almost instantly.I assume the slow performa[详细]

2023-03-14 00:15 分类：问答

MySQL 5.1 using filesort event when an index is present

Probably I\'m missing some silly thing... Apparently MySQL 5.1 keeps doing a Filesort even when there is an index that matches exactly the column in the ORDER BY clause. To post it here, I\'ve oversim[详细]

2023-03-08 13:52 分类：问答

MySQL Explain: what's causing 'Using temporary; Using filesort'

I\'m planning on creating a view using this SQL SELECT, but the explain for it shows it\'s using temporary and using filesort. I can\'t figure out what indices I need in order to fix this problem.[详细]

2023-03-02 12:10 分类：问答

Is there a way to use the index to avoid a filesort when OR is used in MySQL query?

I have the following query and the following 2 indexes, but I am still getting a filesort.Is there a 开发者_StackOverflowway to optimize this further so that I avoid the filesort, or do I just need to[详细]

2023-02-03 07:19 分类：问答