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
- 29248 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
can sql servers linked to other servers like oracle? : Sql dba
Is sql database free?
What is sqlcommand?
What is bind variable in pl sql?
Is truncate ddl or dml?
What is the difference between an inner and outer join?
How subquery works in sql?
is mysql query is case sensitive? : Sql dba
Why do we use sqlite?
How do I find duplicates in two columns?
What is on delete restrict?
Are pl sql variables case sensitive?
What are % type and % rowtype?
What is audit logout in sql profiler?
How would you reference column values before and after you have inserted and deleted triggers?
