Skip to Content
Former Member
Dec 19, 2006 at 07:25 PM

Query Performance on ODS


Hi all,

I have an ODS with around 23000 records. The ODS has around 20 fields in it (3 key fields). I built a query on the ODS. The User only inputs Cost center Hierarchy. The report does not have any calculations. It is a direct view of the fields, but the report is taking a long time to run if I select first 2nd or 3rd level of the hierarchy as the starting point. If I select the 5th or 6th level for the hierarchy then the query output is fast. With just 23000 records on the ODS I thought query performance should be fast for any level of hierarchy.

I even created an index on Costcenter, even then no improvement in performance. Is there any way to achieve faster query performance on the ODS.