• Activity
  • Votes
  • Comments
  • New
  • All activity
    • Showing only topics with the tag "performance". Back to normal view

    16. What are the main considerations/downsides to make before adding an index to a column

      ~comp Text 78 words
      I was asked this question in an interview and I said the downsides would be extra disk space used to store it and more disk writes from the database to maintain the index on updates. I asked a...

      I was asked this question in an interview and I said the downsides would be extra disk space used to store it and more disk writes from the database to maintain the index on updates. I asked a friend and he said the downsides are space used in memory to store the index as well as the fact that an index could take days to build on a large dataset.

      What does everyone here think about this question?

      8 votes