0

I have a table where there are some columns which are empty and they are not used. That table has to be indexed multiple times based on the application. Does having these empty columns in my table slow down the indexing of the other columns or it does not have any effect?

Improve this question
7
  • 1
    When you say "slow down the indexing", do you mean slow down queries, the building of indexes themselves, or something else?
    – George.Palacios
    Commented Apr 25, 2019 at 9:20
  • Just curious - why is an application indexing a table multiple times?
    – Vérace
    Commented Apr 25, 2019 at 11:15
  • Are the unused columns present in any of the indexes?
    – jjanes
    Commented Apr 26, 2019 at 1:39
  • @George.Palacios I meant to say slow down the queries.
    – Aditya Y
    Commented May 3, 2019 at 9:59
  • @Vérace Not the table mostly specific records
    – Aditya Y
    Commented May 3, 2019 at 10:00

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.