Results 1 to 5 of 5

Thread: Index

  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: Index

    Hi,
    I have 2 tables named T1 & T2. Given a scenario, T1 has a clustered index in one of the column. And T2 has a non-clustered index defined on the one of the column (No clustered index defined for T2). My question is, what will be the difference between T1 & T2 regarding physical storage?



    Thanks,
    Rahul Jha

  2. #2
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    Folks,
    No one stands here to answer my query.......???

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you posted a question when most of the people on this forum are asleep

    then you bumped* before most of them even woke up

    you should not need to bump at all (it's against the rules of etiquette) but if you're gonna do it anyway, please wait at least 24 hours



    * bump (verb) -- To post in an Internet forum thread in order to raise the thread's profile by returning it to the top of the list of active threads.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040

    Do a little reasearch first

    Have you even attempted to research your question before posting it? Did you look in BOL? How about the MSoft website? Or even Google?

    There is a plethora of information out there. Be a little proactive!

    1. Look up Clustered Indexes and Nonclustered indexes in BOL.
    2. Google "clustered index storage sql server".

    It took all of 30 seconds to find links to answer your question. Here's just one of them:

    http://www.microsoft.com/technet/pro.../clusivsh.mspx

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

  5. #5
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    thnks tomh53

    thnkx for ur feedback. Ur rgt that we need to do some research work before putting across the query to the forum. Have been doing the same for the last 4 years. But this time had some constraints which stopped me to do teh same. Hence was left with the only option to post the query onto the forum.



    Thanks for the link. Will get back to you all for any other further queries if requires......



    Thanks,
    Rahul Jha

Posting Permissions

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