viewing info about indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: viewing info about indexes

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    viewing info about indexes

    hi

    since indexes are logical structures which keep pointers to tables records. i.e it keeps the rowid for that record which is to be indexed. how would i view this rowid for that record .

    thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What do you mean by logical structure? Index is physical structure and keeps the index data saperately.
    ROWID for a row you can get from the base table.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    select rowid from table_name where_clause
    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
    Apr 2003
    Posts
    46
    thanks for your help

    i had another query. while calculating pctfree for b-tree indexes the formula given is percentage of total space minus the block header. where would i get the block header info from.

    in the manuals they also have mentioned that pctfree parameter for an index works differently from that of a table. what is the differene

    thanks
    Last edited by ser; 07-19-2003 at 12:23 AM.

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