GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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, 2007 09:57:34 #2
 Sandeep Dudhane   Member Since: Visitor    Total Comments: N/A 
RE: my query takes 30 min to refresh ...there is any p...
 
There are various strategies like creating indexes to the columns, creating aggregate tables, creating filters (usually on date columns)
     

 

Back To Question