Archives of the TeradataForum
Message Posted: Tue, 07 Aug 2012 @ 16:30:51 GMT
Some DBMSs will recognize when a query can be resolved by retrieving data only by scanning a secondary index without having to retrieve data from the base table.
Does Teradata apply a similar concept?
For example, a table defined as:
With a PI on ColA and a NUSI on ColC,ColD, if a query selected only ColC and ColD would the query do a single AMP query against the index or would it still use the base table?
Are join indexes the only type of index where the columns in the query matching the columns in the index affect the choice of the index over the base table?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|