Answer the question
In order to leave comments, you need to log in
Is it possible to create an index for a column only for null, or only for non-null?
When you create an index for a column, a new table for indexes is created and the database grows. I need to index only values with null data. To search for 'where column = null'. This will make the database a little smaller than if the contents of the value were not null.
Answer the question
In order to leave comments, you need to log in
When you create an index for a column, a new table is created for the indexes
To search for 'where column = null'.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question