The analyzer can determine how many IOs each approach will take and choose the fastest way to do it.<BR><BR>Basically the estimated execution plan is mostly what the query optimizer does when it's ...
The SQL Query Analyzer is the most polished and functional tool we saw for tuning manual SQL queries. It conveniently displays results in either grid or text format and can interrupt long-running ...