Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 05 Aug 2015 @ 10:25:49 GMT

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

Subj:   Re: NoPI tables as Staging tables
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, August 05, 2015 06:24 -->

Hi Dave,

So is it safe to conclude that the secondary index may be chosen to be used based on the number of qualifying rows, rather than the type of condition (inequality) used ?

In other words Does it mean that even if there is an inequality condition used with the NUSI, the optimizer might still choose to use it if the number of qualifying rows is small ?


  <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