Why PCTUSED is not used in the index definitions?!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Why PCTUSED is not used in the index definitions?!

  1. #1
    Join Date
    Nov 2003
    Location
    Saudi Arabia
    Posts
    25

    Why PCTUSED is not used in the index definitions?!

    Why PCTUSED is not used in the index definitions??!!

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Because it doesn't make any sence, considering the way indexes work internaly and how their blocks are reused. Freelists on indexes behave totaly different meaning and behavior as they have on tables. Read the Concepts Manual....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Beacuse it dosent make any sense to use it..
    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 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Jurij,

    you beat me by fraction of sec
    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"

  5. #5
    Join Date
    Nov 2003
    Location
    Saudi Arabia
    Posts
    25
    Hi
    Could you please provide me with the full name of the manual, cuz i searched in oracle 9i database concepts book but didn't find any thing related to PCTUSED in indexes!

    Thanks in advance

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Read how indexes are stored and manipulated during DML..

    Abhay.
    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"

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Why do you think you would find something on PCTUSED on indexes in the Concepts manual IF IT ISN'T USED!! Try finding the Concepts manual and reading it instead of searching it...

    http://tahiti.oracle.com/

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