Parallel execution is covered reasonably well in the documentation http://download.oracle.com/docs/cd/E11882_01/server.112/e16541/parallel.htm#VLDBG010 and by Doug Burns at http://oracledoug.com/px.pdf On Sun, May 29, 2011 at 6:20 AM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: > Hi Team, > > I have few questions below to know the impact of it: > > The difference between creating the indexes with or without degree. Any > pointers for this topic please shoot. > The impact if indexes being changed from >1 to =1. Will there be any impact > on the programs using those indexes. > The meaning of indexes with degree > 1. > > Thanks, > An > > > -- Niall Litchfield Oracle DBA http://www.orawin.info