Improve performance for fetching records from Data warehouse tables having records in billions

• bharat sethi

  SSCommitted

  Points: 1831

  More actions

  December 6, 2012 at 10:11 am

  #271390

  Dear All,

  Hi! I recently worked on a Data warehouse server which has performance issues. When I dig up the DB wise tables then found that frequently used tables have more than 5 billion records.

  Now, what steps should I take so that the fetching of records from such tables will be optimized? All such tables already have Indexes & the statistics is also getting update on a daily basis.

  Please guide...

• TheMaskedDBA

  SSCrazy

  Points: 2787

  More actions

  December 7, 2012 at 8:48 am

  #1566640

  Too generic and brief a description. Please provide more details of a specific issue. For instance:

  What is the performance issue ? You have to expect some overhead with tables of that size.

  What is the query thats suffering ?

  Have you looked at the execution plan for such a query ? is there scope for optimization of the query ? Is it missing good indexes ?