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
- 29261 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 are myisam tables? : Sql dba
How to return multiple rows from the stored procedure?
What's the difference between a primary key and a clustered index?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the difference between sum and count in sql?
Why query optimization is needed?
What is cte?
What are the operators used in select statements?
how to use myisamchk to check or repair myisam tables? : Sql dba
How do you pronounce sql?
What is insert command in sql?
What is application trigger?
Is it possible to create startup or shutdown trigger for on-schema?
Which tcp/ip port does sql server run?
What is the difference between Union and Union all. Which is faster.
