You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There was a support issue where the customer was tuning their queries and was concerned that the EXPLAIN output showed some full table scans. However, this was expected since the customer was testing with empty tables, and therefore the stats did not represent the production environment.
We should consider updating the docs to mention that most of the time the optimizer makes the right decision, and if you see a full scan you should (a) make sure that it's actually causing a performance problem, and (b) confirm that the optimizer would actually choose a full scan in the production environment (with correct stats, cluster topology, etc)? Only then should a customer try to override the optimizer's decision.
Rebecca Taft (rytaft) commented:
Opening a new ticket as requested in #18338 (comment) cc @taroface
There was a support issue where the customer was tuning their queries and was concerned that the
EXPLAIN
output showed some full table scans. However, this was expected since the customer was testing with empty tables, and therefore the stats did not represent the production environment.We should consider updating the docs to mention that most of the time the optimizer makes the right decision, and if you see a full scan you should (a) make sure that it's actually causing a performance problem, and (b) confirm that the optimizer would actually choose a full scan in the production environment (with correct stats, cluster topology, etc)? Only then should a customer try to override the optimizer's decision.
Jira Issue: DOC-10000
The text was updated successfully, but these errors were encountered: