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

Thread: question about dba index

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Question

    I have a partitioned table that has indexes. I want to finf out if the indexes are normal or global. I checked the index_type column of dba_indexes and it say normal.
    Does that mean the indexes are global or local?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    It only means it is B*tree index type. For information on partitioning, search the column PARTITIONED in DBA_/ALL_/USER_INDEXES or check the DBA_PART_INDEXES view.
    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
    Apr 2001
    Location
    Berlin
    Posts
    65
    I checked and I could not find the column that contains that information. Can you please tell me the column name under
    dba_part_indexes where I can find if the indexes are global or local?

    Thanks

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Check the column DBA_PART_INDEXES.LOCALITY

    hth,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Local-Global-Prefixed-Non-Prefixed

    Hi, 22nd April 2001 17:04 hrs chennai

    Use

    ALL_PART_INDEXES====>

    LOCALITY column which tells Indicates whether this partitioned index is LOCAL or GLOBAL

    ALIGNMENT Columns Indicates whether this partitioned index is PREFIXED or NON-PREFIXED

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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