MySQL Performance: MySQL => (NOT) NULL Indexes

Members

Help

Home

Home » Performance » MySQL » (NOT) NULL Indexes

Show: Today's Messages :: Show Polls :: Message Navigator

(NOT) NULL Indexes [message #3352]

Tue, 29 July 2008 19:04

mbor
Messages: 2
Registered: July 2008

Junior Member

Hi,

I have little question.
What index should I set on varchar(800) NULL field, if I use it only (beside in SELECT) in WHERE statement with IS (NOT) NULL?
thx

Report message to a moderator

Previous Topic:	Calculate Disk Space Overhead?
Next Topic:	Why does MySQL chew so much virtual memory on Windows?

Goto Forum:

-=] Back to Top [=-

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

]

Current Time: Thu Jul 9 22:23:27 EDT 2009

Total time taken to generate the page: 0.00918 seconds

.:: Contact :: Home ::.

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.