When Indexes Should Be Avoided? – InterviewSolution

InterviewSolution

1.

When Indexes Should Be Avoided?

Answer»

Indexes should be AVOIDED when :

TABLES are SMALL.
Tables that changes frequently.
Columns that are frequently manipulated or having a high NUMBER of NULL VALUES.

Indexes should be avoided when :

Discussion

No Comment Found

Related InterviewSolutions

I Accidentally Deleted Some Important Information From My Sqlite Database. How Can I Recover It?
What Is An Sqlite_corrupt Error? What Does It Mean For The Database To Be "malformed"? Why Am I Getting This Error?
Does Sqlite Support Foreign Keys?
The Sql Standard Requires That A Unique Constraint Be Enforced Even If One Or More Of The Columns In The Constraint Are Null, But Sqlite Does Not Do This. Isn't That A Bug?
What Is The Export Control Classification Number (eccn) For Sqlite?
My Query Does Not Return The Column Name That I Expect. Is This A Bug?
Insert Is Really Slow - I Can Only Do Few Dozen Inserts Per Second?
Case-insensitive Matching Of Unicode Characters Does Not Work?
Why Does Round(9.95,1) Return 9.9 Instead Of 10.0? Shouldn't 9.95 Round Up?
What Is An Sqlite_schema Error, And Why Am I Getting One?