vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > Curious, I ran this one using set explain: Same kind of thing going on in 11.10, except the optimizer drops the right condition (colno >= 1) SELECT MIN(colno) FROM syscolumns WHERE colno>=1 AND colno>1 Estimated Cost: 101 Estimated # of Rows Returned: 1 1) informix.syscolumns: INDEX PATH (1) Index Keys: tabid colno (Key-Only) Index Key Filters: (informix.syscolumns.colno > 1 ) 10.00 bug obviously, wonder if it is fixed in versions >= UC6 AND versions > UC6. Andrew |