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

Which method is used to find that the object is exited or not?

2 Answers  


What’s the difference between the methods sleep() and wait()?

1 Answers  


How can you say HashMap is syncronized?

14 Answers   Arete, IBM,


What is difference between static class and normal class?

1 Answers  


Can we catch more than one exception in a single catch block?

1 Answers  


What restrictions are placed on method overloading?

1 Answers  


How can you say java is object oriented?

1 Answers  


What is the difference between synchronized and synchronized block?

1 Answers  


To set the position and size of a component, which methods are used?

3 Answers  


What is the difference between jdk, jre, and jvm?

1 Answers  


what is a package?

11 Answers  


Is there a case when finally will not execute?

1 Answers  


Categories