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

How to answer "Have you ever been terminated?"

Storing hydrofluoric acid before the invention of plastics

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

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

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

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

How do I keep my slimes from escaping their pens?

Why did the IBM 650 use bi-quinary?

What is the meaning of the new sigil in Game of Thrones Season 8 intro?

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

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

Extract all GPU name, model and GPU ram

List of Python versions

Why aren't air breathing engines used as small first stages

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

Echoing a tail command produces unexpected output?

Bete Noir -- no dairy

What does an IRS interview request entail when called in to verify expenses for a sole proprietor small business?

Why are Kinder Surprise Eggs illegal in the USA?

List *all* the tuples!

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

Short Story with Cinderella as a Voo-doo Witch

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

How widely used is the term Treppenwitz? Is it something that most Germans know?



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

          ValueError: Error when checking input: expected conv2d_13_input to have shape (3, 150, 150) but got array with shape (150, 150, 3)2019 Community Moderator ElectionError when checking : expected dense_1_input to have shape (None, 5) but got array with shape (200, 1)Error 'Expected 2D array, got 1D array instead:'ValueError: Error when checking input: expected lstm_41_input to have 3 dimensions, but got array with shape (40000,100)ValueError: Error when checking target: expected dense_1 to have shape (7,) but got array with shape (1,)ValueError: Error when checking target: expected dense_2 to have shape (1,) but got array with shape (0,)Keras exception: ValueError: Error when checking input: expected conv2d_1_input to have shape (150, 150, 3) but got array with shape (256, 256, 3)Steps taking too long to completewhen checking input: expected dense_1_input to have shape (13328,) but got array with shape (317,)ValueError: Error when checking target: expected dense_3 to have shape (None, 1) but got array with shape (7715, 40000)Keras exception: Error when checking input: expected dense_input to have shape (2,) but got array with shape (1,)

          Image
          Do I have a twin with permutated remainders? Maximum likelihood parameters deviate from posterior distributions How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America? What's that red-plus icon near a text? Theorems that impeded progress How can I prevent hyper evolved versions of regular creatures from wiping out their cousins? Today is the Center Modeling an IP Address Alternative to sending password over mail? Pattern match does not work in bash script Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"? Fully-Firstable Anagram Sets RSA: Danger of using p to create q Did Shadowfax go to Valinor? US citizen flying to France today and my passport expires in less than 2 months How do I draw and define two right triangles next to each other? How does strength of boric acid solution increase in presence of ...
          Read more

          Ружовы пелікан Змест Знешні выгляд | Пашырэнне | Асаблівасці біялогіі | Літаратура | НавігацыяДагледжаная версіяправерана1 зменаДагледжаная версіяправерана1 змена/ 22697590 Сістэматыкана ВіківідахВыявына Вікісховішчы174693363011049382

          Image
          Уразлівыя відыЖывёлы паводле алфавітаПеліканыПтушкі ЕўразііПтушкі АфрыкіЖывёлы, апісаныя ў 1758 годзе птушкаАрэалБалканы (function()var node=document.getElementById("mw-dismissablenotice-anonplace");if(node)node.outerHTML="u003Cdiv class="mw-dismissable-notice"u003Eu003Cdiv class="mw-dismissable-notice-close"u003E[u003Ca tabindex="0" role="button"u003Eн...
          Read more

          Illegal assignment from SObject to ContactFetching String, Id from Map - Illegal Assignment Id to Field / ObjectError: Compile Error: Illegal assignment from String to BooleanError: List has no rows for assignment to SObjectError on Test Class - System.QueryException: List has no rows for assignment to SObjectRemote action problemDML requires SObject or SObject list type error“Illegal assignment from List to List”Test Class Fail: Batch Class: System.QueryException: List has no rows for assignment to SObjectMapping to a user'List has no rows for assignment to SObject' Mystery

          Image
          How to determine the actual or "true" resolution of a digital photograph? How to figure out whether the data is sample data or population data apart from the client's information? Can someone publish a story that happened to you? Why do computer-science majors learn calculus? Please, smoke with good manners Normal subgroup of even order whose nontrivial elements form a single conjugacy class is abelian Why does processed meat contain preservatives, while canned fish needs not? TikZ how to make supply and demand arrows for nodes? Is there a way to get a compiler for the original B programming language? Why is the origin of “threshold” uncertain? Upright [...] in italics quotation Will a top journal at least read my introduction? get exit status from system() call How to delegate to implementing class Why are the 2nd/3rd singular forms of present of « potere » irregular? Confused by notation of atomic number Z and mass number A on period...
          Read more