Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2003
    Posts
    364

    Unanswered: URGENT! Interview Question

    Anyone know the answer to this? Looks an awfull lot like a trick question.

    How long will it take to create a non-clustered index comprised of 5 columns with each column being 50 bytes wide? The table has 6 million rows and an average row size of 2000 bytes. The hard drive system is comprised of 5 disks, which spin at 15,000RPMs and are setup in a RAID 5 configuration

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ummm... a long time?

    What about the number of CPU's and their speed, and how much memory...

    The real answer is that it would be a poor choice to make an index with those columns

    What's the PK of the table?

    Are they looking for Index only seek? Those columns make a 1/4 of the sizwe of the row...

    Bad index...bad
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Posts
    364
    Sorry I can't provide more info. That's exactly what was asked of me.

  4. #4
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95

    Lightbulb

    "It Depends"
    Sorry to be terse
    some say it's a curse
    I know it's worse
    I'm just diverse

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I say it's a trick question because building such an index would be a bad idea

    This doesn't answer you question, but it's a good read

    http://www.sql-server-performance.co...ed_indexes.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Sep 2003
    Posts
    364
    Thanks, that's what I was thinking but I wanted to make sure.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It's a trick question. Actually, YOU are the only one going to St. Ives. The other people (wives, cats, etc...) are heading in the OPPOSITE direction. So you see....wait a minute...oops.

    Sorry, wrong thread. I meant to post this on the Oracle forum...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    If it was for the Oracle forum, wouldn't their be politivcal/racial overtones?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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