• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

index's object_id

what is the difference between the object_id of 2 digits vs the object_ids with 9/10 digits?

example: 14 vs 149575571

1 Solution
Kyle AbrahamsSenior .Net DeveloperCommented:
How long has the DB been around and how often are objects created.

Essentially there should be no difference, just that one was created extremely early and the other was created later on.

anushahannaAuthor Commented:
It is only in 1/2 digits or 9/10 digits. There are only totally 200 index in all in the database.
Raja Jegan RSQL Server DBA & ArchitectCommented:
Simple difference between them is that they are for System indexes vs User defined indexes ( This is managed by System to differentiate the type of index)

Indexes in System related tables would have index id as 1/2 digits and if you have more objects in system tables, then it would span upto 3 digits.

And Indexes in User created tables would ideally span from 8 to 10 digits..
And that's entirely managed by SQL Server..

In my database, I can see index id's with 8 digits..

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now