[Sadaf Afzal]

Suppose, you are working in a company as a database expert and company wants to create its database where most of the operations are write intensive and database needs to be updated on regular basis. Whereas, some of the tasks require frequent read operations to display important reports to users. While designing database, company also wants to make sure the efficient use of storage devices during data storage.

Now, you are required to suggest your company whether it should implement Indexing while designing its database or not? Provide at least two proper reasons to support your answer.


discuss here ....

[Admin]

It is a tricky question, not that straight forward to answer.
But here is something that can help: Pros and Cons of Indexing in Database