Re: ______SQL & Index Question

Article View: comp.databases.oracle.misc

Article #109

Back to comp.databases.oracle.misc Previous Next

#109

From: Roman Starek
Date: Thu, 14 Sep 2000 00:00

27 lines
1616 bytes

: say I have a table with many columns and 100.000 rows.
: Table is also partitioned in 10 pieces according to the values in Column C:

:     Column B has 70.000 different values
:     Column C has 10 different values.

: I'll query the table always giving two arguments for B and C.

: How should I index this table:

	I think indexing C collumn is unneded cause Oracle can prune
right partition from definition of partition. So index column B locally
will be helpfull, I hope so.

	Starous




: --
: Thanks in advance

: Emre AKBAG

: akbag@scr.siemens.com
: Siemens Corporate Research

Technical Details

Message-ID: <8pqq41$qas$1@crax.cesnet.cz>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <ZB5w5.1149$l35.16541@iad-read.news.verio.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,f21e719eb8eb6bf4
X-Google-Attributes: gidfb53f,public
X-Google-Thread: fa4f9,f21e719eb8eb6bf4
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,f21e719eb8eb6bf4
X-Google-Attributes: gidf99a8,public
X-Google-Thread: f5464,f21e719eb8eb6bf4
X-Google-Attributes: gidf5464,public
From: Roman Starek <starek@pluto.spsselib.hiedu.cz>
Subject: Re: ______SQL & Index Question
Date: 2000/09/14
Message-ID: <8pqq41$qas$1@crax.cesnet.cz>
X-Deja-AN: 670258841
References: <ZB5w5.1149$l35.16541@iad-read.news.verio.net>
X-Complaints-To: usenet@news.cesnet.cz
X-Trace: crax.cesnet.cz 968944577 26972 194.108.45.169 (14 Sep 2000 15:16:17 GMT)
Organization: CESNET z.s.p.o.
User-Agent: tin/pre-1.4-19990517 ("Psychonaut") (UNIX) (Linux/2.2.16-3smp (i586))
NNTP-Posting-Date: 14 Sep 2000 15:16:17 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools,hannover.uni.comp.oracle,comp.databases.oracle.server

Reply to Parent Message