Hi all,

Sorry to be a pain asking this question, but am a little confused over what
type of index's to create - just want some definitive clarification :

I have a text field, say aField CHAR(20) that I search on using :

SELECT * FROM aTable
WHERE
 UPPER(aField) LIKE 'ASTRING%'

What type of index/compression/case-sensitive etc should I create on aField???

TIA,

Tim.

Tim

I would go for case-insensitive full compression BUT you need to alter your sql to

SELECT * FROM aTable
WHERE
UPPER(aField) LIKE UPPER('ASTRING%')

Roy Lambert

Tim,

<< What type of index/compression/case-sensitive etc should I create on
aField??? >>

Roy is correct - case-insensitive index with full compression, and make the
adjustment to the query to include the UPPER() around the constant.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks guys - Takes the guess work out of it all when your brain has been
fried from 3 days non-stop solid coding .....

Can now sleep .... ahhhhhhh.......


> Tim,
>
> << What type of index/compression/case-sensitive etc should I create
> on aField??? >>
>
> Roy is correct - case-insensitive index with full compression, and
> make the adjustment to the query to include the UPPER() around the
> constant.
>