Hi people, I would like to some suggestion to search person name in a table that has more than 150 milions of rows ... e.g ... name like 'JOHN%SMITH'; I know there is contrib Tsearch, but I can't for political reasons. Is there any way to do with good performance??? Thank you. Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings