What are the different ways to optimize a sql query?


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

Post New Answer

More SQL PLSQL Interview Questions

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  


What is a pdo connection?

0 Answers  


What does cursor do in sql?

0 Answers  


Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,


Why truncate is used in sql?

0 Answers  






What are three advantages to using sql?

0 Answers  


What are the types of records?

0 Answers  


How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  


how to write utl file pkg in SQL

1 Answers   Oracle,


List the ways to get the count of records in a table?

0 Answers  


What is procedure explain with program?

0 Answers  


there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,


Categories