DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Index scan

  1. 06-25-2003, 04:15 AM #1
    newcomer
    newcomer is offline Member
    Join Date
    May 2002
    Posts
    163

    Index scan

    Hi Guys

    Please tell me the difference and significance of 'Index Unique Scan' , 'index range scan' and index full scan'.

    I will appreciate your time.

    Thanks
    Nwcomer
    Student
    Reply With Quote Reply With Quote
  2. 06-25-2003, 04:30 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Take a look at this document it explains how to interpret an explain plan and the defintions you listed are explained.

    http://support.oracle.co.uk/metalink...T&p_id=46234.1

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 06-25-2003, 04:31 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Unique, Range, Full...the name itself tells the difference.
    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"
    Reply With Quote Reply With Quote
  4. 06-25-2003, 04:44 AM #4
    newcomer
    newcomer is offline Member
    Join Date
    May 2002
    Posts
    163
    Funky is Funny ... as name itself describes
    Nwcomer
    Student
    Reply With Quote Reply With Quote
  5. 06-25-2003, 05:01 AM #5
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by newcomer
    Funky is Funny ... as name itself describes
    GR8.....one needs to be Funny for funny Qz
    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"
    Reply With Quote Reply With Quote
  6. 06-25-2003, 05:02 AM #6
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by newcomer
    Funky is Funny ... as name itself describes
    Funky doesn't mean funny.
    Out of curiosity just saw in dictionary.com Interesting..
    http://dictionary.reference.com/search?q=funky
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  7. 06-25-2003, 05:10 AM #7
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by SANJAY_G
    Funky doesn't mean funny.
    Out of curiosity just saw in dictionary.com Interesting..
    http://dictionary.reference.com/search?q=funky
    Sanjay :

    i think, the post should be titled as Funky Scan
    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"
    Reply With Quote Reply With Quote
  8. 06-25-2003, 05:42 AM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    unique and range, itself explains all
    Reply With Quote Reply With Quote
  9. 06-25-2003, 05:48 AM #9
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Ahh Pando Does Agree with me

    Though newcomer,Sanjay_G are keen to search Funky meaning.
    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"
    Reply With Quote Reply With Quote
  10. 06-25-2003, 05:51 AM #10
    TomazZ
    TomazZ is offline Junior Member
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by pando
    unique and range, itself explains all
    a little more difficult with 'full', though
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width