|
Archives of the TeradataForumMessage Posted: Tue, 31 Jan 2006 @ 22:22:17 GMT
A column is taken in consideration for SI after looking at the frequency of the use. I have seen even after using the column that has SI in the where clause yet the Explain shows a full table scan. Hence the question of when does the optimizer think full table scan is better then using SI. I guess it is the row count. Thanks
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||