Archives of the TeradataForum
Message Posted: Fri, 12 Dec 2003 @ 23:43:33 GMT
Table column and index are two distinct physical database objects. Their stats also. COLLECT STATS COLUMN, for instance, might not be enough to make the optimizer use the index in situations where the index can potentially be used. COLLECT STATS INDEX will be better in such cases.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|