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

Can a method be static?

757


Explain java coding standards for interfaces?

876


Can a constructor call another constructor?

782


Why is stringbuffer not immutable?

807


If we allocate the memory using 'new' & de-allocated using 'free' then what will happen?

827


How will you reverse a singly-link list?

801


What is a parameter used for?

754


What is difference between path and classpath variables?

839


Can static methods access instance variables in java?

812


What is double checked locking in singleton?

837


Which list does not allow duplicates in java?

732


Why inputstreamreader is used in java?

794


What is a dynamic array java?

744


Can a class be private?

739


Can we override protected method in java?

842