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

Thread: Index

  1. 07-18-2001, 11:34 AM #1
    suresh911
    suresh911 is offline Junior Member
    Join Date
    Jul 2001
    Posts
    5

    Red face

    Could any one pls explain what is mean by Global Index and Local Index. And when, where should we use this indexes?
    Reply With Quote Reply With Quote
  2. 07-18-2001, 11:47 AM #2
    pipo
    pipo is offline Senior Advisor
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    these indexes are used with partitionned tables. a local index is an index which has as many partitions as the table, while a global index can have a different number of partitions (you can index columns which do not belong to the partitionning key)
    Reply With Quote Reply With Quote
  3. 07-18-2001, 12:22 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    These types of indexes only come into play with partitioned tables. A global index is an index that is partitioned different then the table it is indexing. A local index is partitioned with the same scheme as the base table.

    See http://technet.oracle.com/docs/produ...rti.htm#430374 for reference.
    Jeff Hunter
    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