Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> parallel clause for indexes...

parallel clause for indexes...

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Sun, 14 May 2006 20:27:11 +0200
Message-ID: <39idnQfe6ogf6_rZRVnyvQ@giganews.com>


Hi!
Does the parallel clause for indexes affect anything beyond creation? Also, if I have created a table woth the parallel clause, the table can be used in parallel. What about the indexes associated with the table? Can they be used by more than one query too? Or by the same query twice, like in a self join?

(10.2.0.1, linux)
Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.
Received on Sun May 14 2006 - 13:27:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US