Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?
- 12 Answers
- 29155 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / bala
By avoiding sql statements & select INTO kind of statements.
To improve better creating cursors to hold data.
Indexing is the way to tune the database tables.
so, mostly try to avoid Hard Coding in the select
statements..
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Mention what plvcmt and plvrb does in pl/sql?
What does 0 mean in sql?
What is an ndf file?
Why are sql stored procedures used?
When is a declare statement required?
What do you understand by exception handling in pl/sql?
Why commit is not used in triggers?
What are the parameter modes supported by pl/sql?
What is nvarchar max in sql?
Is inner join faster than left join?
What is sql query limit?
What are the different sql commands?
how can you create an empty table from an existing table? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is coalesce in sql?
