Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regarding Index Usage

AB312062Mar 26 2013 — edited Mar 27 2013
Hi

I have some doubts regarding Indexes:

1. What is the difference between the below 2 index usage scenarios:
/*+ index(a index_name) parallel(a,4)*/
/*+ parallel_index(a,index_name,4)*/

Are both these same?

2. What is full index scan and fast full index scan?

3. I have a table created in database and it has a few indexes on some columns. How can I check whether the index is Bitmap or B-Tree ?


Thanks
AB
This post has been answered by Peter Gjelstrup on Mar 26 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2013
Added on Mar 26 2013
#index
2 comments
78 views