On 17/11/2010 14:31, Paul Vinkenoog wrote:
> Hello Werner,
>
>>> SELECT NAME FROM CEPAGE_SYN WHERE UPPER(NAME) STARTING 'SEMILLON' ORDER
>>> BY NAME;
>>>
>>> PLAN (CEPAGE_SYN ORDER CEPAGE_SYN_IDX1)
>>>
>>> Why is the above not using the index but below is?
> I suppose that CEPAGE_SYN_IDX1 orders on NAME, not UPPER(NAME).
>
Yeap, that was it.

Werner