How to index a table in Oracle?

Question

Oracle

There is a procedure written on Oracle. When started, this procedure runs for about 7-8 hours. How can you speed up the process?
ps. development environment - pl/sql developer

Answer 1

I'll surprise you, but there is no "Do Good" button in Oracle. Here it is necessary to trace. And to look why the optimizer uses the plan which so long works.
Most likely you will need:
Create Index , Dbms_stats .

Answer 2

you need to set fast = true in the init.ora settings and that's it ...)))

Answer 3

Hmm... How the fuck is the question worded!
Here already offered to index indexes?
And if the procedure does not select, but updates? And on each update in the table on 3 triggers works. And additional indexes will only aggravate the situation.
Who knows what this "procedure" does inside - conclusions can be drawn only on the basis of the title of the question, because staff telepath on vacation...