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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment