Archives of the TeradataForum
Message Posted: Mon, 07 Feb 2011 @ 17:46:03 GMT
| Subj: || || Re: Which query will be faster ? |
| From: || || John_Wight |
| ||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!