 |
 |
Archives of the TeradataForum
Message Posted: Mon, 07 Feb 2011 @ 17:46:03 GMT
| Subj: | | Re: Which query will be faster ? |
| |
| From: | | John_Wight |
Anomy.Anom wrote:
| | I have a following query : If on the same table I fire the following 4 queries , which one will execute faster ? (rather how PE interprets
them ?) | |
Put the word EXPLAIN at the front of each and run it - it will tell you how it's going to execute and give you a cost estimate. If you don't
know this, the COST estimate is in time and that does NOT give you the actual execution time - nothing can - you have to actually run it. But if
more recent releases, the times to execute are getting more 'realistic' - but they can still be way off!
Pretty elementary dear Watson, elementary!
JK
| |
