What is the main reason behind using an index?

DWQA Questions › Category: Pl/SQL › What is the main reason behind using an index?

0 Vote Up Vote Down

<img alt='' src='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=48&r=g' srcset='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=96&r=g 2x' class='avatar avatar-48 photo' height='48' width='48' />

Editor Staff asked 12 months ago

What is the main reason behind using an index?

Question Tags: PL/SQL

1 Answers

0 Vote Up Vote Down

<img alt='' src='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=48&r=g' srcset='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=96&r=g 2x' class='avatar avatar-48 photo' height='48' width='48' />

Editor Staff answered 12 months ago

Faster access of data blocks in the table.