Storing and fast retrieving of Email address
Hi All,
I have a large table (3.4M rows) that contains users informations.
The primary key is the Email address, indexed, and I want to speed-up the query time.
I'm thinking to change the email field from plain text to some other datatype, like an Hash or a numerical value.
Can anyone help me to find a correct and fastest datatype?
p.s. The tipycal query is quite simple: SELECT filed1, field2,field3 FROM Users WHERE email ='123@123.com'
Thanks,
Carlo
Subject
Views
Written By
Posted
Storing and fast retrieving of Email address
11508
March 17, 2008 04:42PM
4156
March 20, 2008 08:21AM
3285
March 25, 2008 05:54PM
2919
March 25, 2008 07:34PM
2726
May 29, 2008 09:53AM
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.