Answer Detail: RE: my query takes 30 min to refresh ...there is any p...

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?

July 07, 2007 10:27:31	#3
jay jaiswal	Member Since: Visitor Total Comments: N/A
RE: my query takes 30 min to refresh ...there is any p...
You can partition the table, create proper indexes on that column, You can define key type in Object Definition, Use aggregate Awareness.