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.
Tuesday, July 04, 2006
Subscribe to:
Posts (Atom)
