What is meant by Static query and Dynamic query?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the main purpose of java?

510


Explain OOPs concept.

641


What is equlas() and hashcode() contract in java? Where does it used?

600


How to reverse a string in java?

513


What is the difference between state-based unit testing and interaction-based unit testing?

491






describe method overloading

529


Can a final variable be manipulated in java?

524


What is variable and its types?

537


What is the main function in java?

523


What is the arraylist in java?

523


Which sorting algorithm is best in java?

529


What is struts in java?

566


What are the elements of java?

551


What is the latest java version?

550


Explain the use of javap tool.

628