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?
5142
July 10, 2005 09:25AM
2518
July 10, 2005 11:55AM
2828
July 18, 2005 08:17AM
2861
July 18, 2005 09:04AM
2427
July 18, 2005 09:04AM
2720
July 18, 2005 09:57AM
2464
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.