Re: UNUSED INDEX on CHAR fields

<sklusmann_at_my-deja.com> schrieb:

> [Problems with optimizer]
> TABLE ACCESS FULL for V_BTYPEN is strange, because the field "name" of
> this table (char(16)) is indexed even unique and the compared field
> v_typ is of the same type and size.

Which version?
How big is the table?

Regards
Kathinka Received on Wed Jun 28 2000 - 00:00:00 CDT