database parameters for a data warehouse environment - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: database parameters for a data warehouse environment

  1. #11
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by mike9
    [B]Who of you ever work on a larger DWH project? Because in a DWH envrionment I realy don't see why the optimizer mode "all_rows" should be a problem.
    The only circumstance in which I've used first_rows is in ETL processing, where the ETL has been on a different machine that has proved to be the performance bottleneck. In that case I wanted the ETL server to start processing as soon as possible, and used FIRST_ROWS. Other than that, it's ALL_ROWS every time.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #12
    Join Date
    Mar 2002
    Posts
    534
    Originally posted by slimdave
    The only circumstance in which I've used first_rows is in ETL processing, where the ETL has been on a different machine that has proved to be the performance bottleneck. In that case I wanted the ETL server to start processing as soon as possible, and used FIRST_ROWS. Other than that, it's ALL_ROWS every time.
    nice to see that at least some poeple have a real experience in this area...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width