|
> 有没有这句话的出处
Diagnosing Why a Query is Not Using an Index [ID 67522.1]
Are the indexed columns NULLable?
Indexes do NOT store NULL values unless the index is concatenated (i.e. multi-column indexes), or it is a Bitmap index. For concatenated indexes NULLs are only stored if at least one of the indexed columns is filled. ... Rows are not stored if all the indexed columns are NULL. |
|