0 - 3 of 3 tags for physical design

Hi,
Is it possible to get the below information any any DBC/Pdcrdata tables ?
1. if a PPI is defined for a table then how many times is it used by the queries during a sampling period ?
2. How many times queries use the PI/SI of the table in their where/join conditions ?

Everyone is taught how to collect statistics in order to make Teradata queries run well but what if you've collected all the statistics that you can and you STILL have bad performance?

It's well-known that the application of database optimization techniques can improve query performance.