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

What causes the vertical darker bands in my photo?

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

Ring Automorphisms that fix 1.

String `!23` is replaced with `docker` in command line

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

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

Do I really need recursive chmod to restrict access to a folder?

Why light coming from distant stars is not discreet?

porting install scripts : can rpm replace apt?

Is it true that "carbohydrates are of no use for the basal metabolic need"?

Using et al. for a last / senior author rather than for a first author

Why didn't this character "real die" when they blew their stack out in Altered Carbon?

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

How to find all the available tools in mac terminal?

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

What does this icon in iOS Stardew Valley mean?

Is the Standard Deduction better than Itemized when both are the same amount?

What is Arya's weapon design?

Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?

Output the ŋarâþ crîþ alphabet song without using (m)any letters

How to deal with a team lead who never gives me credit?

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

Single word antonym of "flightless"

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



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?






sql-server index







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?






    sql-server index







    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?






      sql-server index







      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




      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

          Reverse int within the 32-bit signed integer range: [−2^31, 2^31 − 1]Combining two 32-bit integers into one 64-bit integerDetermine if an int is within rangeLossy packing 32 bit integer to 16 bitComputing the square root of a 64-bit integerKeeping integer addition within boundsSafe multiplication of two 64-bit signed integersLeetcode 10: Regular Expression MatchingSigned integer-to-ascii x86_64 assembler macroReverse the digits of an Integer“Add two numbers given in reverse order from a linked list”

          Image
          C++ debug of nlohmann json using GDB Is this toilet slogan correct usage of the English language? Symbol used to indicate indivisibility What if a revenant (monster) gains fire resistance? Is aluminum electrical wire used on aircraft? Closed-form expression for certain product Strong empirical falsification of quantum mechanics based on vacuum energy density How should I respond when I lied about my education and the company finds out through background check? Pre-mixing cryogenic fuels and using only one fuel tank How do you respond to a colleague from another team when they're wrongly expecting that you'll help them? How can I block email signup overlays or javascript popups in Safari? How to implement a feedback to keep the DC gain at zero for this conceptual passive filter? Count the occurrence of each unique word in the file Why electric field inside a cavity of a non-conducting sphere not zero? If infinitesimal transformations commute why dont ...
          Read more

          Category:Fedor von Bock Media in category "Fedor von Bock"Navigation menuUpload mediaISNI: 0000 0000 5511 3417VIAF ID: 24712551GND ID: 119294796Library of Congress authority ID: n96068363BnF ID: 12534305fSUDOC authorities ID: 034604189Open Library ID: OL338253ANKCR AUT ID: jn19990000869National Library of Israel ID: 000514068National Thesaurus for Author Names ID: 341574317ReasonatorScholiaStatistics

          Image
          1880 births1945 deathsFedor (given name)Recipients of the Pour le Mérite (military class)Recipients of the Military Merit Cross (Austria-Hungary)Knight's Cross of the Iron Cross recipientsRecipients of the Order of Michael the BraveRecipients of the Order of the Crown (Prussia)Recipients of the Order of the Crown (Württemberg)Recipients of the House Order of HohenzollernRecipients of the Order of the Zähringer LionRecipients of the Hanseatic CrossRecipients of the House Order of the Wendish CrownRecipients of the Order of the Iron CrownGrand Master of the Order of Military Merit (Bulgaria)Recipients of the Order of the Yugoslav CrownRecipients of the Order of Merit of the Republic of HungaryRecipients of the Cross of HonorKnights Grand Cross of the Order of the Crown of ItalyBock (surname)19th-century men of Germany20th-century men of GermanyField Marshals of the Heer (Wehrmacht)Generals of the ReichswehrHeer Knight's Cross of the Iron Cross recipientsMen of Germany by na...
          Read more

          Kiel Indholdsfortegnelse Historie | Transport og færgeforbindelser | Sejlsport og anden sport | Kultur | Kendte personer fra Kiel | Noter | Litteratur | Eksterne henvisninger | Navigationsmenuwww.kiel.de54°19′31″N 10°8′26″Ø / 54.32528°N 10.14056°Ø / 54.32528; 10.14056Oberbürgermeister Dr. Ulf Kämpferwww.statistik-nord.deDen danske Stats StatistikKiels hjemmesiderrrWorldCat312794080n790547494030481-4

          Image
          DitmarskenFlensborgLauenburgKielLübeckNeumünsterNordfrislandØstholstenPinnebergPlönRendsborg-EgernførdeSlesvig-FlensborgSegebergSteinburgStormarnStuttgartMannheimKarlsruheFreiburg im BreisgauHeidelbergHeilbronnUlmPforzheimReutlingenBerlinBremenBremerhavenFrankfurt am MainWiesbadenKasselDarmstadtOffenbach am MainHannoverBraunschweigOsnabrückOldenburgWolfsburgGöttingenHildesheimSalzgitterMainzLudwigshafen am RheinKoblenzTrierDresdenLeipzigChemnitzKielLübeckKaunasKlaipėdaPärnuRigaTallinnTartuViljandiPolotskElblagGdanskKrakówStargard SzczecinskiSzczecinTorunWroclawBerwick-upon-TweedBostonGreat YarmouthKing's LynnKingston upon HullIpswichLeithLondonNewcastle upon TyneYork Byer i Slesvig-HolstenKielHanse NordtysklandhovedstadendelstatenSlesvig-HolstenTysklandsKielerfjordenØstersøenLangelandÆrøHamborgEjderenVesterhavetdansktyskslavisk1865Kielerkanalen1918novemberrevolutionenoprør blandt matrosernekejserlige marineW...
          Read more