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

What is a layout manager and what are different types of layout managers available in java awt?

0 Answers  


Is null a string in java?

0 Answers  


What is java util function?

0 Answers  


Why java is secure? Explain.

0 Answers  


How does linkedhashmap work in java?

0 Answers  






What is data abstraction? Elaborate with example?

4 Answers   BMC, TCS,


when i write string s1="java"; in one program(application) and string s2="java"; in another application on the same jvm will both objects s2,s2 will refer to same memory location where "java" is stored in string pool.

2 Answers  


What is instance means in java?

0 Answers  


What is skeleton and stub?

0 Answers  


What if static is removed from main method?

0 Answers  


What are decalarations?

0 Answers  


What is the use of default method in interface in java?

0 Answers  


Categories