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?
5205
July 10, 2005 09:25AM
2554
July 10, 2005 11:55AM
2852
July 18, 2005 08:17AM
2894
July 18, 2005 09:04AM
2452
July 18, 2005 09:04AM
2759
July 18, 2005 09:57AM
2485
July 18, 2005 10:54AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.