Archives of the TeradataForum
Message Posted: Wed, 05 Aug 2015 @ 10:25:49 GMT
<-- Anonymously Posted: Wednesday, August 05, 2015 06:24 -->
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|