Re: Query with variables very slow
Posted by:
Rick James
Date: January 28, 2012 06:41PM
To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
Cursor? Are you sure you can't do the loop in a single SELECT?
Subject
Views
Written By
Posted
2433
January 27, 2012 10:38PM
Re: Query with variables very slow
1171
January 28, 2012 06:41PM
2184
January 28, 2012 10:16PM
1260
January 29, 2012 07:09PM
1280
January 30, 2012 02:18AM
1289
January 30, 2012 03:39AM
1131
January 31, 2012 03: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.