Re: Query Efficiency
Pivot tables look elegant but often are very costly to execute. The answer to your question Probably depends on the RDBMS, and certainly depends on what indexes are available. The main tool for estimating query efficiency in MySQL is EXPLAIN EXTENDED. Don't know what the comparable tool is in Oracle or SQL Server. You would have to run the queries through those tools in each RDBMS and compare the compare the answers.
Subject
Views
Written By
Posted
2451
September 20, 2013 06:30AM
Re: Query Efficiency
917
September 20, 2013 11:04AM
964
September 25, 2013 04:29AM
780
October 01, 2013 08:42AM
876
October 01, 2013 08:53AM
812
September 30, 2013 06:13PM
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.