Is this a good situation for an Index ?

From: Mark <marki.NOSPAM_at_libero.it>
Date: Thu, 25 Sep 2003 10:04:42 GMT
Message-ID: <_4zcb.345710$Ny5.11008401@twister2.libero.it>

Hi all DBAs,
I have a table (of about 30.000 records) with a varchar2 field 'CODE' in it. All 'CODE' have different values (even if there isn't a unique constraint in it).
Since CODE is in the WHERE clause, is it a good situation for using an index on it ? does it have some overhead to index a non numeric column ?

A last question: if I want to retrieve rows with CODE that begins with 'A' ? will this prevent the index to be used ?

Thanks a lot for your patience
Mark Received on Thu Sep 25 2003 - 05:04:42 CDT