Member Avatar for Emily_3

Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!

  • 2 Contributors
  • 1 Reply
  • 154 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

An execution plan is a description of how the database is going to carry out your query. It can show you what happens and in what order, plus detailing how much 'effort' went into each step. This allows you to see bottle necks and locate where slow performing queries are going wrong. You don't create an execution plan yourself, just to be clear, it's handled completely by the database engine.
Indexes allow for more efficient searching of tables, basically by giving the database a way of sorting the data. Adding indexes to sow queries can be a good way to get some performance gains out of them.
Indexes, what they are, how they work and how to create them, is a big topic. I would suggest spending some time on Google to get a good basic knowledge of them.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.