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

Identifying polygons that intersect with another layer using QGIS?

How can I make names more distinctive without making them longer?

What exactly is a "Meth" in Altered Carbon?

Is it fair for a professor to grade us on the possession of past papers?

Understanding Ceva's Theorem

List of Python versions

How to answer "Have you ever been terminated?"

Echoing a tail command produces unexpected output?

Why is "Consequences inflicted." not a sentence?

When do you get frequent flier miles - when you buy, or when you fly?

Dating a Former Employee

Book where humans were engineered with genes from animal species to survive hostile planets

How to tell that you are a giant?

Why are there no cargo aircraft with "flying wing" design?

How to find all the available tools in mac terminal?

Single word antonym of "flightless"

How discoverable are IPv6 addresses and AAAA names by potential attackers?

When were vectors invented?

What is Arya's weapon design?

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

How to find out what spells would be useless to a blind NPC spellcaster?

How to react to hostile behavior from a senior developer?

Ring Automorphisms that fix 1.

Why do we bend a book to keep it straight?



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;








2















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




























    2















    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
























      2












      2








      2








      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

      213413




      213413




















          1 Answer
          1






          active

          oldest

          votes


















          4














          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









          4














          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















          4














          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













          4












          4








          4







          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

          名間水力發電廠 目录 沿革 設施 鄰近設施 註釋 外部連結 导航菜单23°50′10″N 120°42′41″E / 23.83611°N 120.71139°E / 23.83611; 120.7113923°50′10″N 120°42′41″E / 23.83611°N 120.71139°E / 23.83611; 120.71139計畫概要原始内容臺灣第一座BOT 模式開發的水力發電廠-名間水力電廠名間水力發電廠 水利署首件BOT案原始内容《小檔案》名間電廠 首座BOT水力發電廠原始内容名間電廠BOT - 經濟部水利署中區水資源局

          Prove that NP is closed under karp reduction?Space(n) not closed under Karp reductions - what about NTime(n)?Class P is closed under rotation?Prove or disprove that $NL$ is closed under polynomial many-one reductions$mathbfNC_2$ is closed under log-space reductionOn Karp reductionwhen can I know if a class (complexity) is closed under reduction (cook/karp)Check if class $PSPACE$ is closed under polyonomially space reductionIs NPSPACE also closed under polynomial-time reduction and under log-space reduction?Prove PSPACE is closed under complement?Prove PSPACE is closed under union?

          Is my guitar’s action too high? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Strings too stiff on a recently purchased acoustic guitar | Cort AD880CEIs the action of my guitar really high?Μy little finger is too weak to play guitarWith guitar, how long should I give my fingers to strengthen / callous?When playing a fret the guitar sounds mutedPlaying (Barre) chords up the guitar neckI think my guitar strings are wound too tight and I can't play barre chordsF barre chord on an SG guitarHow to find to the right strings of a barre chord by feel?High action on higher fret on my steel acoustic guitar