An index is implicitly created when a NOT NULL constraint is added to a table.

Name: An index is implicitly created when a NOT NULL constraint is added to a table.
Brand: Quizplus
Rating: 4.9 (33 reviews)

Question

An index is implicitly created when a NOT NULL constraint is added to a table.​

Quizplus · Accepted Answer

An index is not automatically created when a NOT NULL constraint is added to a table. Indexes are typically created explicitly by the user or automatically with primary key and unique constraints, not with NOT NULL constraints.

An Index Is Implicitly Created When a NOT NULL Constraint