Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Partial index on an email column
Partial index on an email column [message #1574] Mon, 06 August 2007 15:53 Go to previous message
cizara is currently offline cizara
Messages: 3
Registered: August 2007
Location: Argentina
Junior Member
Hi, I have a table with a column email that currently have an index. The data on the table has almost all their emails from hotmail.com (like 90% over 40M). I want to do a partial index on that table to search only until the @.... Is there a way to do this or I have to do a partial index of for example 12 lenght?

Thanks,
Cizara
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:Multiple databases vs. multiple tables
Next Topic:MySQL large table update/insert
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 00:24:12 EDT 2009

Total time taken to generate the page: 0.02006 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.