Bug #19372 Optimizer does not use index anymore when WHERE index NOT IN () is added
Submitted: 26 Apr 2006 11:57 Modified: 17 Apr 2007 19:56
Reporter: Jochen Riehm Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.0.22-BK, 5.0.19 OS:Linux (Debian Linux, Kernel 2.6.8)
Assigned to: Georgi Kodinov CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[26 Apr 2006 11:57] Jochen Riehm
Table dump of test case

Attachment: index_where_not_in_table.sql.bz2 (application/x-bzip2, text), 190.24 KiB.