Re: Huge temp file on simple select
Posted by:
Rick James
Date: April 06, 2014 07:30PM
> ORDER BY ICOF ASC LIMIT 1000 OFFSET 67000
That must sort by ICOF, then skip over 67000 rows, then deliver 1000. The sort seems to be requiring the large temp space.
Please provide
SHOW CREATE TABLE res1za3c
There are a couple of tips I can give you after seeing the table definition.
Also, please explain why you are doing LIMIT & OFFSET. (Some applications do it for webpage pagination; that seems unlikely here. Some do it for dumping. Some have other reasons.)
Subject
Views
Written By
Posted
1708
April 05, 2014 10:12AM
Re: Huge temp file on simple select
1158
April 06, 2014 07:30PM
1005
April 07, 2014 03:18AM
851
April 08, 2014 11:20AM
837
April 09, 2014 02:20AM
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.