REPOST: Re: REPOST: Re: global index and local index

From: Stefan <sroesch3_at_attbi.com>
Date: Tue, 01 Jan 2002 04:51:59 GMT
Message-ID: <2$--$$-$-%-%$%%%$$@news.noc.cabal.int>

Uwe Schneider wrote:

> frank wrote:

>> 
>> Hello,
>> 
>> Does global index and local index concept used only in partition?

>
> I have heard about them only in conjunction with partitions.
>

>> Please give me an explanation on what's the difference of them.

>
> Local indexes are partitioned in the same manner as the table segment,
> i.e. the index data are in the same partition as the corresponding table
> data. Global index segments are unpartitioned.
>

That's plain wrong. Local indexes are partitioned with the same partitioning key (or a subset) as the table. Global partitioned indexes can have
a different partioning key. They can even be partitioned with the same key and still be global partitioned, because local indexes have to be created with the table. The difference is that in a global index one index partition may refer to more than one underlying table partition.

The main difference is in the maintenance/administration overhead between the two.

Hope this helps
Stefan

> Uwe
>

• WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: Stefan <sroesch3_at_attbi.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel <PfbY7.2929$4d5.20591_at_rwcrnsc54> Control: cancel <PfbY7.2929$4d5.20591_at_rwcrnsc54> Date: Wed, 2 Jan 2002 01:11:46 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.PfbY7.2929$4d5.20591_at_rwcrnsc54> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009944098 21023 166.102.15.34 (2 Jan 2002 04:01:38 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 04:01:38 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40277462

autocancel Received on Mon Dec 31 2001 - 22:51:59 CST