A method for describing a database query originally developed by IBM for mainframes. A replica of an empty record is displayed and the search conditions are typed in under their respective columns ...
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 ...