SQL performance issue in our Datawarehouse
Hi,
We have a OBIEE dashboard report query in production which was working fine earlier before July and then all of sudden users started complaining that the report never completes. The same report query in lower environments runs fine and we have done analysis and found that the SQL plan is completely different in Production versus Development environment.
The query has all required btree and bitmap indexes same in all environments. First thing we did was we exported the statistics for six tables from dev and imported into production environment. It did solve the problem and the report was running back in 1 minute 30 seconds. We also created a SQL Profile for this particular query with FORCE option along with query stats import.
We have a OBIEE dashboard report query in production which was working fine earlier before July and then all of sudden users started complaining that the report never completes. The same report query in lower environments runs fine and we have done analysis and found that the SQL plan is completely different in Production versus Development environment.
The query has all required btree and bitmap indexes same in all environments. First thing we did was we exported the statistics for six tables from dev and imported into production environment. It did solve the problem and the report was running back in 1 minute 30 seconds. We also created a SQL Profile for this particular query with FORCE option along with query stats import.
0