MySQL Bugs: #18042: Optimizer chooses nonoptimal plan

Bug #18042	Optimizer chooses nonoptimal plan
Submitted:	7 Mar 2006 16:27	Modified:	24 Jan 2014 12:03
Reporter:	Vadim Tkachenko	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S4 (Feature request)
Version:	5.0	OS:	Linux (RedHat)
Assigned to:	Assigned Account	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
With default plan query is executed much slower.

How to repeat:
Please see private note.

- Customer's database has a very peculiar distribution. Without histograms we cannot expect a good optimizer choice here.
 
By the above reasons I move the bug to 'To be fixed later' and mark it as a 'Feature request'.
Product management will decide in what version a fix for this problem appears.