Difference Between Impicit Index and Explicit Cursor

If an implicit index is created when we create a primary key, then what is the need of explicit cursor?

Showing Answers 1 - 3 of 3 Answers

shiva sai

  • Feb 15th, 2016
 

1. Using implicit index the data can be fetched fastly only when the where clause has primary key column.

2. Explicit cursor is used when we want to fetch more than one record and also the where condition does not have primary column.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions