Indexes with the same object_id but different namesWill a clustered index improve performance of updates performed sequentially on that clustered index?Does the number of indexes effect the modification of table?index doesn't work properlyWhy does selecting top 1 from composite index DESC also used to partition by month not select the top value?Creating an index on table A but with reference to table BWhat is the difference in performance between a two single-field indexes and one compound index?Copy a row from a table to another with the same columns but different order in a triggerFind tables with multiple indexes on same columnMS SQL Server differentiate system and user defined indexes using sys.indexes tableQuery to retrieve aggregated data using variables
Why is B♯ higher than C♭ in 31-ET?
Was Unix ever a single-user OS?
Why do money exchangers give different rates to different bills?
Transpose of product of matrices
Why wasn't the Night King naked in S08E03?
Unknowingly ran an infinite loop in terminal
Why is Arya visibly scared in the library in S8E3?
Missed the connecting flight, separate tickets on same airline - who is responsible?
Pressure inside an infinite ocean?
Number of seconds in 6 weeks
Short story with physics professor who "brings back the dead" (Asimov or Bradbury?)
Do I really need diodes to receive MIDI?
What word means "to make something obsolete"?
What actually is the vector of angular momentum?
How can I support myself financially as a 17 year old with a loan?
How can I get a job without pushing my family's income into a higher tax bracket?
What are the differences between credential stuffing and password spraying?
Manager is threatning to grade me poorly if I don't complete the project
60s (or earlier) SF short story with FTL Travel using electron psychology aka addiclenendar technology
What is the most remote airport from the center of the city it supposedly serves?
What happens if I start too many background jobs?
Airbnb - host wants to reduce rooms, can we get refund?
How do I tell my manager that his code review comment is wrong?
Why is ‘eines’ used in the sentence ‘Eines gleich vorweg’?
Indexes with the same object_id but different names
Will a clustered index improve performance of updates performed sequentially on that clustered index?Does the number of indexes effect the modification of table?index doesn't work properlyWhy does selecting top 1 from composite index DESC also used to partition by month not select the top value?Creating an index on table A but with reference to table BWhat is the difference in performance between a two single-field indexes and one compound index?Copy a row from a table to another with the same columns but different order in a triggerFind tables with multiple indexes on same columnMS SQL Server differentiate system and user defined indexes using sys.indexes tableQuery to retrieve aggregated data using variables
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
When I run
SELECT
count(object_id) AS count,
object_id,
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count
I will get a list of indexes having the same object_id, but not necessarily with the same name.
Should not all indexes with the same object_id have the same name?
t-sql index
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
add a comment |
When I run
SELECT
count(object_id) AS count,
object_id,
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count
I will get a list of indexes having the same object_id, but not necessarily with the same name.
Should not all indexes with the same object_id have the same name?
t-sql index
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
add a comment |
When I run
SELECT
count(object_id) AS count,
object_id,
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count
I will get a list of indexes having the same object_id, but not necessarily with the same name.
Should not all indexes with the same object_id have the same name?
t-sql index
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
When I run
SELECT
count(object_id) AS count,
object_id,
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count
I will get a list of indexes having the same object_id, but not necessarily with the same name.
Should not all indexes with the same object_id have the same name?
t-sql index
t-sql index
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
asked Apr 23 at 9:42
Anders LindénAnders Lindén
2671314
2671314
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The Object_ID belongs to the object the index belongs to, such as an indexed view or a table.
When you look at the object_id in the sys.indexes documentation
object_id - ID of the object to which this index belongs.
If you want to uniquely identify the index you need the Object_ID + index_id columns or the index_id for a specific object_id.
To verify this, you can add the OBJECT_NAME() function to your query
SELECT
count(object_id) AS count,
object_id,
OBJECT_NAME(object_id),
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count;
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
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%2f235454%2findexes-with-the-same-object-id-but-different-names%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
The Object_ID belongs to the object the index belongs to, such as an indexed view or a table.
When you look at the object_id in the sys.indexes documentation
object_id - ID of the object to which this index belongs.
If you want to uniquely identify the index you need the Object_ID + index_id columns or the index_id for a specific object_id.
To verify this, you can add the OBJECT_NAME() function to your query
SELECT
count(object_id) AS count,
object_id,
OBJECT_NAME(object_id),
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count;
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
add a comment |
The Object_ID belongs to the object the index belongs to, such as an indexed view or a table.
When you look at the object_id in the sys.indexes documentation
object_id - ID of the object to which this index belongs.
If you want to uniquely identify the index you need the Object_ID + index_id columns or the index_id for a specific object_id.
To verify this, you can add the OBJECT_NAME() function to your query
SELECT
count(object_id) AS count,
object_id,
OBJECT_NAME(object_id),
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count;
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
add a comment |
The Object_ID belongs to the object the index belongs to, such as an indexed view or a table.
When you look at the object_id in the sys.indexes documentation
object_id - ID of the object to which this index belongs.
If you want to uniquely identify the index you need the Object_ID + index_id columns or the index_id for a specific object_id.
To verify this, you can add the OBJECT_NAME() function to your query
SELECT
count(object_id) AS count,
object_id,
OBJECT_NAME(object_id),
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count;
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
The Object_ID belongs to the object the index belongs to, such as an indexed view or a table.
When you look at the object_id in the sys.indexes documentation
object_id - ID of the object to which this index belongs.
If you want to uniquely identify the index you need the Object_ID + index_id columns or the index_id for a specific object_id.
To verify this, you can add the OBJECT_NAME() function to your query
SELECT
count(object_id) AS count,
object_id,
OBJECT_NAME(object_id),
min(name) as name1,
max(name) AS name2
FROM
sys.indexes
GROUP BY object_id HAVING COUNT(*) > 1 ORDER BY count;
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
answered Apr 23 at 9:46
Randi VertongenRandi Vertongen
5,3611926
5,3611926
add a comment |
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%2f235454%2findexes-with-the-same-object-id-but-different-names%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
