Best Structure for UK Post Code Table
Posted by: Graham Wallace
Date: January 21, 2011 04:22AM

Hello

We have a table with 1.7million UK Post codes with a column for the post code as the primary key and column with a single letter. We only ever want to retrieve a single record by the post code.

I’m just wondering the best practice for Table and Indexing structure for the above?

Thank you for your help in advance.

Graham

Options: ReplyQuote


Subject
Written By
Posted
Best Structure for UK Post Code Table
January 21, 2011 04:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.