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

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

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

How do I keep my slimes from escaping their pens?

Apollo command module space walk?

In predicate logic, does existential quantification (∃) include universal quantification (∀), i.e. can 'some' imply 'all'?

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

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

What is Arya's weapon design?

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

Compare a given version number in the form major.minor.build.patch and see if one is less than the other

How to find all the available tools in mac terminal?

Fundamental Solution of the Pell Equation

Okay to merge included columns on otherwise identical indexes?

How do pianists reach extremely loud dynamics?

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

Can a USB port passively 'listen only'?

Why light coming from distant stars is not discreet?

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

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

What's the meaning of 間時肆拾貳 at a car parking sign

What is Wonderstone and are there any references to it pre-1982?

ListPlot join points by nearest neighbor rather than order

porting install scripts : can rpm replace apt?

Why did the IBM 650 use bi-quinary?



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

          Virtualbox - Configuration error: Querying “UUID” failed (VERR_CFGM_VALUE_NOT_FOUND)“VERR_SUPLIB_WORLD_WRITABLE” error when trying to installing OS in virtualboxVirtual Box Kernel errorFailed to open a seesion for the virtual machineFailed to open a session for the virtual machineUbuntu 14.04 LTS Virtualbox errorcan't use VM VirtualBoxusing virtualboxI can't run Linux-64 Bit on VirtualBoxUnable to insert the virtual optical disk (VBoxguestaddition) in virtual machine for ubuntu server in win 10VirtuaBox in Ubuntu 18.04 Issues with Win10.ISO Installation

          Image
          Fear of getting stuck on one programming language / technology that is not used in my country Do the primes contain an infinite almost arithmetic progression? Biological Blimps: Propulsion Are Captain Marvel's powers affected by Thanos' actions in Infinity War Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size? Can a College of Swords bard use a Blade Flourish option on an opportunity attack provoked by their own Dissonant Whispers spell? Can disgust be a key component of horror? Can I say "fingers" when referring to toes? What is Cash Advance APR? Why Shazam when there is already Superman? What does "Scientists rise up against statistical significance" mean? (Comment in Nature) What does chmod -u do? What should you do when eye contact makes your subordinate uncomfortable? Issue while creating Apex class using API How much character growth crosses the line into breaking the charac...
          Read more

          Are there any comparative studies done between Ashtavakra Gita and Buddhim?How is it wrong to believe that a self exists, or that it doesn't?Can you criticise or improve Ven. Bodhi's description of MahayanaWas the doctrine of 'Anatta', accepted as doctrine by modern Buddhism, actually taught by the Buddha?Relationship between Buddhism, Hinduism and Yoga?Comparison of Nirvana, Tao and Brahman/AtmaIs there a distinction between “ego identity” and “craving/hating”?Are there many differences between Taoism and Buddhism?Loss of “faith” in buddhismSimilarity between creation in Abrahamic religions and beginning of life in Earth mentioned Agganna Sutta?Are there studies about the difference between meditating in the morning versus in the evening?Can one follow Hinduism and Buddhism at the same time?Are there any prohibitions on participating in other religion's practices?Psychology of 'flow'

          Image
          Why "be dealt cards" rather than "be dealing cards"? Have I saved too much for retirement so far? The plural of 'stomach" How do I rename a LINUX host without needing to reboot for the rename to take effect? What defines a dissertation? Why are on-board computers allowed to change controls without notifying the pilots? Bash method for viewing beginning and end of file Student evaluations of teaching assistants Opposite of a diet Go Pregnant or Go Home Valid Badminton Score? What's the purpose of "true" in bash "if sudo true; then" What is the intuitive meaning of having a linear relationship between the logs of two variables? The baby cries all morning Is there a good way to store credentials outside of a password manager? Can I use my Chinese passport to enter China after I acquired another citizenship? Why Were Madagascar and New Zealand Discovered So Late? What are the ramifications of creating a ...
          Read more

          fallocate: fallocate failed: Text file busy in Ubuntu 17.04? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)defragmenting and increasing performance of old lubuntu system with swap partitionIssue with increasing the root partition from the swapthis /usr/bin/dpkg returned error || ubuntu-16.04, 64bitDefault 17.04 swap file locationHow to Resize Ubuntu 17.04 Zesty Swap file size?Ubuntu freezes from online formsMy Laptop is not starting after upgrade ubuntu 16.04 (Kernel 4.8.0-38 to 04.10.0-36)hcp: ERROR: FALLOCATE FAILED!Not sure my swap is being usedWine 3.0 asking for more virtual free swap

          Image
          Why does Python start at index 1 when iterating an array backwards? Letter Boxed validator What's the purpose of writing one's academic bio in 3rd person? What is the longest distance a 13th-level monk can jump while attacking on the same turn? What are 'alternative tunings' of a guitar and why would you use them? Doesn't it make it more difficult to play? Can Pao de Queijo, and similar foods, be kosher for Passover? When -s is used with third person singular. What's its use in this context? Right-skewed distribution with mean equals to mode? Should gear shift center itself while in neutral? Are my PIs rude or am I just being too sensitive? When is phishing education going too far? If 'B is more likely given A', then 'A is more likely given B' List *all* the tuples! Is high blood pressure ever a symptom attributable solely to dehydration? Is there a service that would inform me whenever a new direct route is scheduled ...
          Read more