Entries from The Data Warehouse Insider tagged with 'optimizer statistics'

Class: Optimizer - Good things get even better (Aug 5)

This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific Time. Since its introduction in Oracle7, people have been fascinated...

Managing Optimizer statistics in an Oracle Database 11g

Knowing when and how to gather optimizer statistics has become somewhat of dark art especially in a data warehouse environment where statistics maintenance can be hindered by the fact that as the data set increases the time it takes to...