al Message -
From: "Boehn, Gunnar von"
Sent: Tuesday, November 18, 2003 4:23 AM
Subject: Feature wish
> Hi,
>
> I wonder if a small enhancement to the
> mysql planner/optimizer could be made.
>
>
> The current (mysql4.0) optimizer only uses one index per SELECT.
&
Hi,
I wonder if a small enhancement to the
mysql planner/optimizer could be made.
The current (mysql4.0) optimizer only uses one index per SELECT.
Because of this some queries result in a slow fulltable scan
even if all used columns are indexed.
Example:
SELECT * FROM table1 WHERE columnA='x' O
