DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: index creation

  1. #1
    Join Date
    Dec 2004
    Location
    Nigeria
    Posts
    26

    index creation

    Can an index be created on more than one column? If so, why doesn't it cause confusion?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have a read of the section on indexing in the Concepts Guide at http://tahiti.oracle.com
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Confusion... why????
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Dec 2004
    Location
    Nigeria
    Posts
    26
    Thanks for info. And sorry if I seem to be asking silly questions. I don't much help from the people around me.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by CNN
    Thanks for info. And sorry if I seem to be asking silly questions. I don't much help from the people around me.
    If you read the concepts guide cover-to-cover then you'll probably know a lot more those around you.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by slimdave
    If you read the concepts guide cover-to-cover then you'll probably know a lot more those around you.
    just add understand it as well

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by davey23uk
    just add understand it as well
    Well, if you're going to be picky ...
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I wouldn't blame those around me for what's NOT in my head.

    Duck folks, we're next.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by slimdave
    Well, if you're going to be picky ...
    hadn't said anything in a while, you know how it is

Posting Permissions

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


Click Here to Expand Forum to Full Width