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 -> Re: parallel clause for indexes...

Re: parallel clause for indexes...

From: sybrandb <sybrandb_at_yahoo.com>
Date: 15 May 2006 01:10:40 -0700
Message-ID: <1147680640.116318.253630@v46g2000cwv.googlegroups.com> 





parallel doesn't mean a table can be accessed by more than one query.
Giving your posting history, this is an amazing and troublesome remark.
You should have known better!



Parallel means a full table scan will be divided in n partial scans,
where n is the number of parallel query slaves available.
For indexes the parallel option applies only to index full scan and
index fast full scan access paths.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Mon May 15 2006 - 03:10:40 CDT












Original text of this message













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