Gather Stats on P6 Reporting Database Star Schema Tables
I have installed the P6 reporting database (3.0) and loaded it with our P6 data using the staretl.bat script. However, a lot of our queries and charts in OBIEE running against the star schema tables are now running very slowly. I have tried to gather stats on the star schema tables but they are locked. Does anyone know (i) if I am supposed to gather the table stats to improve query performance ?, or (ii) how do I do this ?.
Many thanks
Nik