Re: which is better filesort or temporary?
Posted by:
Rick James
Date: September 26, 2008 11:50PM
Argument for filesort... It is automatic; less code.
Argument for CREATE TEMPORARY TABLE...
1. You could add indexes to that table; this could greatly speed up subsequent work.
2. If you need the temp table for two things, you will be computing it only once.
See also tunables max_heap..., etc.
Subject
Views
Written By
Posted
3718
June 09, 2008 06:24AM
2350
June 09, 2008 06:22PM
2345
June 13, 2008 03:55AM
Re: which is better filesort or temporary?
2203
September 26, 2008 11:50PM
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.