index's object_id

Posted on 2009-12-23
Last Modified: 2012-05-08
what is the difference between the object_id of 2 digits vs the object_ids with 9/10 digits?

example: 14 vs 149575571

Question by:anushahanna
    LVL 39

    Expert Comment

    by:Kyle Abrahams
    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.

    LVL 6

    Author Comment

    It is only in 1/2 digits or 9/10 digits. There are only totally 200 index in all in the database.
    LVL 57

    Accepted Solution

    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..

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
    Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now