QUOTE (URNetMate @ Feb 10 2007, 09:31 AM)
I have a master table of postcodes and appropriate street,county,country details for each postcode.
Now on selection of postcode all the relative details have to be fetched.
Now searching from millions of records it takes considerable time...and i just want to reduce that..
I don't know how postcode work in your country, but in the UK a single postcode is associated with about 30 addresses. If you index the postcode column on the table I would expect you to get a really quick response, even with millions of records in the table.