Hi people, I have a case and I got a doubt what should be the best ways. One table has more than 150 million of rows, and I thought that could divided by state. For each row has person ID, state and other informations, but the search would be done only by person ID (number column). I can improve the query by putting index in that column, but is there any other ways? 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly