Re: SELECT query running for 9h (till now)
Posted by:
Rick James
Date: August 07, 2013 07:54PM
To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
and surround them with [ code ] and [ / code ]
How many rows are you expecting to get?
Note that it estimates 720K from the "ref" table.
Subject
Views
Written By
Posted
2636
August 05, 2013 10:40AM
Re: SELECT query running for 9h (till now)
1479
August 07, 2013 07:54PM
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.