(NOT) NULL Indexes

mbor July 29, 2008, 5:34pm 1

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

Topic		Replies	Views
IS NOT NULL condition - MySQL doesn't use index Other MySQL® Questions	2	11958	April 28, 2016
mysql not using index Other MySQL® Questions	1	327	February 1, 2007
indexes for an OR based query (mysql 4.1.11) Other MySQL® Questions	2	399	December 16, 2007
MySQL Query Optimization - Trouble with Indices Other MySQL® Questions	2	504	November 3, 2009
where is the performance hit with null values in indexes? Other MySQL® Questions	1	380	June 7, 2010

(NOT) NULL Indexes

Related topics