| |
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?
|
| August 08, 2007 01:04:40 |
#4 |
| Tilak kumar |
Member Since: Visitor Total Comments: N/A |
RE: my query takes 30 min to refresh ...there is any p...
|
1) Frequently used tables only you need to create the indexes.
2) Partioning the tables
3) Reduce the user defined objects
4) Always use the conditions, avoid string concatenations. |
| |
Back To Question | |
