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's the difference between an abstract class and interface in java?

550


What is argument in java?

532


What is meant by final class?

560


What is t type java?

620


How to convert string to byte array and vice versa?

578






What is an array in java?

636


Can we write any code after throw statement?

599


What is the use of java?

524


What is the current version of java?

535


Why is serialization required?

535


What is regex in java?

525


What's the default access specifier for variables and methods of a class?

506


Is java pass by value or pass by reference?

532


What is the synonym of string?

529


what is the use of pojo (plain old java objects)? how it is interact with crystal reports? pls urgent

1725