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
- 29126 Views
- IBM, TCS, UHD, I also Faced
- E-Mail Answers
Answer Posted / dipti
By using Indexs we can improve the performace,
also use exist and not exist in place of in and not in as
it plays the same role as Index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between inner join and outer join?
What is sql data?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are the sql aggregate functions?
Advantages and disadvantages of stored procedure?
Differentiate between sga and pga.
Inline the values in PL/SQL, what does it mean.?
What is pl sql collection?
What are the usages of sql?
How do I run a query in pl sql developer?
What are the types of join and explain each?
What does the base_object_type column shows in the user.triggers data dictionary view?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What are the types of views in sql?
How do you update f as m and m as f from the below table testtable?
