Re: Storing and fast retrieving of Email address
Thanks Phil,
yes my SE is InnoDb.
> If so, then make sure the primary key is actually
> the clustered index
yes it is
> If you have 5.1, this would be an ideal place for
> partitioning if you used an id (integer) for
> email.
Yes I have 5.1, but now the email field is a CHAR
I'm thinking to convert it to Integer but this is the question... char to bigint, how to? (to be able to perform a straight query like: ... WHERE mailId = WhatFunction('pippo@example.com'))
Then partitioning then is the best suggestion, I agree.
Carlos
Subject
Views
Written By
Posted
11509
March 17, 2008 04:42PM
4156
March 20, 2008 08:21AM
Re: Storing and fast retrieving of Email address
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.