I have an experience using LIKE in a VARCHAR column and select statement
suffers a lot so I decided to go back in CHAR 

Note: my database has about 50 millions records a b tree index 

> Can I use an index on a varchar column to optimize the SELECT queries  
> that
> use " column LIKE 'header%'  "?


> If yes what is the best tree algotithm to use ?


        Note that if you want case insensitive matching you need to make an
on lower(column) and SELECT WHERE lower(column) LIKE 'header%'

        Locales may bite you.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

__________ NOD32 1.1023 (20050310) Information __________

This message was checked by NOD32 Antivirus System.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to