When we do not prefer to create index
A column contains large no of values
A column contains large no of null values
Table is small
When table is not updated frequently