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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the impact of declaring a method as final?

772


What is the difference between array and array list in java?

806


Can you explain the meaning of aggregation and composition

774


What is outofmemoryerror in java?

772


What invokes a thread's run() method in java programming?

818


How to convert string to char and vice versa?

745


What if I write static public void instead of public static void in java?

834


What are the advantages of unicode?

788


Which method you will use to create a new file to store some log data. Each time a new log entry is necessary, write string to the file in java ?

928


What is an iterator java?

753


What is difference between c++ and java ?

885


How does arrays sort work in java?

812


Difference between method overloading and overriding.

798


How can constructor chaining be done by using the super keyword?

869


what do you understand by synchronization? Or what is synchronization and why is it important? Or describe synchronization in respect to multithreading? Or what is synchronization? : Java thread

716