What is meant by Static query and Dynamic query?

Answers were Sorted based on User's Feedback



What is meant by Static query and Dynamic query?..

Answer / malli


Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.

Is This Answer Correct ?    3 Yes 1 No

What is meant by Static query and Dynamic query?..

Answer / malli


Static query will create an execution plan during compilation.

Dynamic query will create execution plan at run time.
Its very slow in execution since building the plan at run
time makes it too slow.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Core Java Interview Questions

Can java hashmap have duplicate keys?

0 Answers  


What is native method in java?

0 Answers  


What is the difference between ArrayList and Vector? which one is better in Java

0 Answers   SkillGun Technologies,


Can you pass functions in java?

0 Answers  


When to use runnable interface vs thread class in java?

0 Answers  






What is the order of arraylist in java?

0 Answers  


Why is it called buffering?

0 Answers  


Differentiate constructor and a method and how are it be used?

7 Answers   Wipro,


Is java type safe?

0 Answers  


Give differences between Quicksort &Mergesort. When should these sorts be used andwhat is their running time in java?

0 Answers   Genpact,


What are the classes of java?

0 Answers  


what is webservices?

1 Answers   CTS, Ericsson, HCL,


Categories