Alex,
sorry, but it is not a planned enhancement for a long time. For small
columns it is as good to create an index on the whole column, because
there is at least some 15-byte space overhead for secondary index records
anyway. For large columns the application can add an extra column to the
table where it puts a few first characters of the large column.
Regards,
Heikki
At 04:03 PM 4/12/01 +0200, you wrote:
>Heikki,
>
> Could you please tell me (and add in the manual perhaps) if this is
> a planned enhancement or not and if it's planned, if it will be
> added in a long or a short delay.
>
> Thanks,
> Alex.
>
>HT> Innobase does not support partial-field indexes. We have to block their
>HT> usage in the SQL parser. Miguel's query on Win NT perhaps worked
because the
>HT> optimizer there chose another access path and did not use the partial-field
>HT> index.
>
>HT> But thank you Alex, we have to block them in the parser, and I will
>HT> update the Innobase online manual immediately.
>
>HT> Regards,
>
>HT> Heikki
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php