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;
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
asked 6 hours ago
BVernonBVernon
213413
add a comment |
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
asked 6 hours ago
BVernonBVernon
213413
add a comment |
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
asked 6 hours ago
BVernonBVernon
213413
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
asked 6 hours ago
BVernonBVernon
213413
asked 6 hours ago
BVernonBVernon
213413
asked 6 hours ago
BVernonBVernon
213413
asked 6 hours ago
BVernonBVernon
213413
asked 6 hours ago
BVernonBVernon
213413
213413
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)
– BVernon
4 hours ago
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)
– BVernon
4 hours ago
add a comment |
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
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
Thanks. I just combined like 5 indexes and shed close to a gigabyte of data, lol. :)
– BVernon
4 hours ago
add a comment |
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
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
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
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
answered 5 hours ago
Erik DarlingErik Darling
22.9k1269113
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
add a comment |
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
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
