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

why java does not support unsigned keyword?

4748


What is oops in java?

800


How is abstraction implemented in java ?

746


Explain the access modifiers for a class, method and variables?

926


Differences between C and Java?

862


Can we change the scope of the overridden method in the subclass?

1100


What is method with example?

814


Is null a string in java?

781


Why singleton class is used in java?

848


Explain OOPs concept.

872


How many characters is 16 bytes?

786


What are thread local variables?

804


Explain the difference between intermediate and terminal operations in java8?

833


what is the difference between process and thread? : Java thread

798


What is autoboxing in java?

845