Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 07 Feb 2011 @ 17:46:03 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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!


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023