Archives of the TeradataForum
Message Posted: Fri, 30 Apr 2004 @ 12:40:59 GMT
A SI is said to be covered when your query selects only those columns that are defined on the SI. That way only SI sub-table row is read and the request satisfied withput reading the base table table row.
The explaination is somewhere in one of the manuals that discusses all the INDEX choices.
Hope that helps
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|