SQL syntax appears correct but EXPLAIN does not work?
This query here will run (in fact for hours) so I wanted to find out why it is so slow.
UPDATE SECM_SECURITY_UNIVERSE, PREFERRED_STOCK_INFORMATION, BOND_CORE_INFORMATION, CONVERTIBLE_BOND_INFO
SET SECM_SECURITY_UNIVERSE.STAMP = NOW()
WHERE (SECM_SECURITY_UNIVERSE.ASSET_ID = PREFERRED_STOCK_INFORMATION.ASSET_ID AND PREFERRED_STOCK_INFORMATION.PROCESSED>0)
OR (SECM_SECURITY_UNIVERSE.ASSET_ID = BOND_CORE_INFORMATION.ASSET_ID AND BOND_CORE_INFORMATION.PROCESSED>0)
OR (SECM_SECURITY_UNIVERSE.ASSET_ID = CONVERTIBLE_BOND_INFO.ASSET_ID AND CONVERTIBLE_BOND_INFO.PROCESSED>0)
I tried it in MySQL Query Browser and it gives a syntax error message from the start of the statement. I tried it in the cmd line MySQL window with a EXPLAIN on the front to, same error? So how come it will run but EXPLAIN will not work on it?
Thx,
David
Subject
Views
Written By
Posted
SQL syntax appears correct but EXPLAIN does not work?
5104
July 10, 2005 09:25AM
2486
July 10, 2005 11:55AM
2803
July 18, 2005 08:17AM
2832
July 18, 2005 09:04AM
2403
July 18, 2005 09:04AM
2694
July 18, 2005 09:57AM
2431
July 18, 2005 10:54AM
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.