OraFAQ Forum: Server Administration » Index Option

Home » RDBMS Server » Server Administration » Index Option - Parallel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index Option - Parallel [message #144864]

Fri, 28 October 2005 11:16

felipevinturini
Messages: 10
Registered: August 2005
Location: Brazil

Junior Member

Hi All Oracle Experts!!!

I have a simple question but I don't know where to find this information.

My question is: which table do I have to select to know if a index has the parallel option enabled?

Thanks.

Report message to a moderator

Re: Index Option - Parallel [message #144892 is a reply to message #144864]

Fri, 28 October 2005 13:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You mean, created in parallel?

scott@9i > create index indx1 on emp(ename);

Index created.

scott@9i >  create index indx2  on emp(empno)  parallel;

Index created.

scott@9i >  create index indx3 on emp(job) parallel 4;

Index created.

scott@9i > select index_name ,degree from user_indexes;

INDEX_NAME                     DEGREE
------------------------------ ----------------------------------------
INDX1                          1
INDX2                          DEFAULT
INDX3                          4

Report message to a moderator

Previous Topic:	How to migrate Oracle 8i to 10G on solaris
Next Topic:	when a SCN is assigned to the transaction?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 13:00:08 CST 2025