Okay to merge included columns on otherwise identical indexes? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)SQL server indexing foreign keys, covering indexes included columnsdifference between having many non clustered index with single columns and with combination of many columnsTwo identical MySQL tables, one not using indexesAre these indexes redundant?Does Index Intersection work with Included Columns?Effect of an index on update statements where update column is not in an indexSQL Server : Included columns in an Index: is there something like “too many”?Any reason to have both an index with included columns and one without?Index creation with multiple columns - should I combine as many as possible?Table/Column Character Encoding and Indexes

Check which numbers satisfy the condition [A*B*C = A! + B! + C!]

Why is "Consequences inflicted." not a sentence?

What is the logic behind the Maharil's explanation of why we don't say שעשה ניסים on Pesach?

At the end of Thor: Ragnarok why don't the Asgardians turn and head for the Bifrost as per their original plan?

How does debian/ubuntu knows a package has a updated version

Why was the term "discrete" used in discrete logarithm?

Generate an RGB colour grid

What causes the vertical darker bands in my photo?

Should I discuss the type of campaign with my players?

Can I cast Passwall to drop an enemy into a 20-foot pit?

Why am I getting the error "non-boolean type specified in a context where a condition is expected" for this request?

What does this icon in iOS Stardew Valley mean?

Dating a Former Employee

How much time will it take to get my passport back if I am applying for multiple Schengen visa countries?

Why did the rest of the Eastern Bloc not invade Yugoslavia?

Why light coming from distant stars is not discrete?

When a candle burns, why does the top of wick glow if bottom of flame is hottest?

Sci-Fi book where patients in a coma ward all live in a subconscious world linked together

Can an alien society believe that their star system is the universe?

Can a non-EU citizen traveling with me come with me through the EU passport line?

How come Sam didn't become Lord of Horn Hill?

Okay to merge included columns on otherwise identical indexes?

Using audio cues to encourage good posture

Why did the Falcon Heavy center core fall off the ASDS OCISLY barge?



Okay to merge included columns on otherwise identical indexes?



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)SQL server indexing foreign keys, covering indexes included columnsdifference between having many non clustered index with single columns and with combination of many columnsTwo identical MySQL tables, one not using indexesAre these indexes redundant?Does Index Intersection work with Included Columns?Effect of an index on update statements where update column is not in an indexSQL Server : Included columns in an Index: is there something like “too many”?Any reason to have both an index with included columns and one without?Index creation with multiple columns - should I combine as many as possible?Table/Column Character Encoding and Indexes



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








3















I have two indexes that index the same field on the same table. The only difference between them is the included columns.



There's no reason I shouldn't combine the included columns and just have one index, right?










share|improve this question




























    3















    I have two indexes that index the same field on the same table. The only difference between them is the included columns.



    There's no reason I shouldn't combine the included columns and just have one index, right?










    share|improve this question
























      3












      3








      3








      I have two indexes that index the same field on the same table. The only difference between them is the included columns.



      There's no reason I shouldn't combine the included columns and just have one index, right?










      share|improve this question














      I have two indexes that index the same field on the same table. The only difference between them is the included columns.



      There's no reason I shouldn't combine the included columns and just have one index, right?







      sql-server index






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 6 hours ago









      BVernonBVernon

      218413




      218413




















          1 Answer
          1






          active

          oldest

          votes


















          5














          Yes, you should merge these indexes and only keep one, as long as you verify that:



          • Neither of them are marked as UNIQUE (in which case, preserve that one)


          • Neither of them have a filter condition


          • Neither of them are expressly referenced in an index hint






          share|improve this answer























          • Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

            – BVernon
            4 hours ago











          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "182"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234982%2fokay-to-merge-included-columns-on-otherwise-identical-indexes%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          5














          Yes, you should merge these indexes and only keep one, as long as you verify that:



          • Neither of them are marked as UNIQUE (in which case, preserve that one)


          • Neither of them have a filter condition


          • Neither of them are expressly referenced in an index hint






          share|improve this answer























          • Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

            – BVernon
            4 hours ago















          5














          Yes, you should merge these indexes and only keep one, as long as you verify that:



          • Neither of them are marked as UNIQUE (in which case, preserve that one)


          • Neither of them have a filter condition


          • Neither of them are expressly referenced in an index hint






          share|improve this answer























          • Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

            – BVernon
            4 hours ago













          5












          5








          5







          Yes, you should merge these indexes and only keep one, as long as you verify that:



          • Neither of them are marked as UNIQUE (in which case, preserve that one)


          • Neither of them have a filter condition


          • Neither of them are expressly referenced in an index hint






          share|improve this answer













          Yes, you should merge these indexes and only keep one, as long as you verify that:



          • Neither of them are marked as UNIQUE (in which case, preserve that one)


          • Neither of them have a filter condition


          • Neither of them are expressly referenced in an index hint







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 5 hours ago









          Erik DarlingErik Darling

          22.9k1269113




          22.9k1269113












          • Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

            – BVernon
            4 hours ago

















          • Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

            – BVernon
            4 hours ago
















          Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

          – BVernon
          4 hours ago





          Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)

          – BVernon
          4 hours ago

















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234982%2fokay-to-merge-included-columns-on-otherwise-identical-indexes%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Nidaros erkebispedøme

          Birsay

          Where did Arya get these scars? Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar Manara Favourite questions and answers from the 1st quarter of 2019Why did Arya refuse to end it?Has the pronunciation of Arya Stark's name changed?Has Arya forgiven people?Why did Arya Stark lose her vision?Why can Arya still use the faces?Has the Narrow Sea become narrower?Does Arya Stark know how to make poisons outside of the House of Black and White?Why did Nymeria leave Arya?Why did Arya not kill the Lannister soldiers she encountered in the Riverlands?What is the current canonical age of Sansa, Bran and Arya Stark?