Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Posts
    18

    Unanswered: SQL Server Indexing again

    Dear Masters,

    I want to know how SQL Server (non clustered) index works when I do an insert query? 1000 queries? there is no clustered index, no primary key. just non clustered index.

    is it same like this?
    Code:
    http://en.wikipedia.org/wiki/B-tree#Insertion
    Thx 4 your expertise.

    Regards,
    Wiwin.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/b7d6b323-728d-4763-a987-92e6292f6f7a.htm

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/1efeba1f-f848-4861-9af3-594e5ab3b597.htm

    both of these are 2005 BOL notations ... enjoy the reading

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Jan 2009
    Posts
    18
    OMG.. hehehe..

    Thx, tomh53.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •