Posted 02 Oct 2014
The accuracy of sample statistics has been greatly improved over the last Teradata releases. So I usually try to use sample stats on most of the big tables and I found them to be reliable on many columns, not only the officially recommended unique or nearly-unique columns, e.g. on DATEs. But there is a specific scenario when sample stats result in worst case optimizer plans: |
Thank you Dieter
|