Return to Question

Clarified that I'm asking about index on blobfield

Source Link

edited Mar 17, 2014 at 19:18

I need to do the simple query SELECT id FROM table WHERE blob_field IS NULL.

blob_field is a longblob. If I create an index on blob_field with prefix length 1, will this be sufficient to use for this query?

I need to do the simple query SELECT id FROM table WHERE blob_field IS NULL.

blob_field is a longblob. If I create an index with prefix length 1, will this be sufficient to use for this query?

I need to do the simple query SELECT id FROM table WHERE blob_field IS NULL.

blob_field is a longblob. If I create an index on blob_field with prefix length 1, will this be sufficient to use for this query?

Source Link

asked Mar 17, 2014 at 19:01

MySQL Index for searching for NULL values in text fields

I need to do the simple query SELECT id FROM table WHERE blob_field IS NULL.

blob_field is a longblob. If I create an index with prefix length 1, will this be sufficient to use for this query?

mysql index blob