Tuesday, July 04, 2006

Increase (database) performance when dealing with Hummingbird

As Hummingbird creates its queries on the fly you might end up with queries that perform well when the database is using an OPTIMIZER_MODE=RULE, as well as queries that perform well when the database OPTIMIZER_MODE is set to COST.

It seems that with good statistics and an OPTIMIZER_MODE=FIRST_ROWS best of both worlds can be achieved.