| |
GeekInterview.com > Interview Questions > Data Warehousing > Business Objects
| Print | |
Question: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?
|
| April 04, 2008 10:16:32 |
#8 |
| rahul07 |
Member Since: April 2008 Total Comments: 2 |
RE: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?
|
1) check for any traps in the universe.
2) use the right context
3) avoid morethan one sub query in the query panel
4) use right context
5) right index on the table
6) partion the table
7) use conditons
8) avoid user defined objects |
| |
Back To Question | |
