Archives of the TeradataForum
Message Posted: Thu, 13 Mar 2003 @ 12:43:53 GMT
Based upon my direct experience, I would recommend collecting statistics on the PI (regardless of UPI or NUPI), the individual columns that comprise the PI, any column used in a join operation, and any column referenced in a WHERE clause. I have seen drastically improved query performance when these steps are taken.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|