Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: global index and local index
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.
Uwe
-- Uwe Schneider | Telefon +49 7244 / 609504 Haydnstr. 1 | Mail uwe_at_richard-schneider.de DE-76356 Weingarten | http://www.richard-schneider.de/uwe Linux - OS al dente! ========= WAS CANCELLED BY =======: Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: Uwe Schneider <uwe_at_richard-schneider.de> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <3C2EF6C2.2B1CA835_at_richard-schneider.de> Control: cancel <3C2EF6C2.2B1CA835_at_richard-schneider.de> Date: Mon, 31 Dec 2001 08:08:02 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.3C2EF6C2.2B1CA835_at_richard-schneider.de> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788834 26548 166.102.15.34 (31 Dec 2001 08:53:54 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:53:54 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes This message was cancelled from within Mozilla...notReceived on Sun Dec 30 2001 - 05:13:06 CST