How do you optimize a query?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is pl sql record in oracle?

0 Answers  


what is bcp? When does it used? : Sql dba

0 Answers  


what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,


What is sql deadlock?

0 Answers  


Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  






what is 'mysqldump'? : Sql dba

0 Answers  


What are wait events. Describe the wait event tables.

1 Answers   CTS,


Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,


Why coalesce is used in sql?

0 Answers  


Explain normalization and what are the advantages of it?

0 Answers  


How many times can we commit in a loop?

0 Answers  


How can get second highest salary in sql?

0 Answers  


Categories