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 are the advantages of exception handling in java?

835


What are invisible components?.

1901


If a variable is declared as private, where may the variable be accessed?

812


What is blank final variable?

798


Why inputstreamreader is used in java?

777


What is Hierarchy of exception?

845


What is a programming object?

781


Does java trim remove newline?

735


What is join () in java?

729


What is immutable in java?

781


Can we override protected method in java?

817


What is meant by stack and queue?

782


Explain java coding standards for methods?

813


How do you declare a destructor in java?

712


What is the difference between Grid and Gridbaglayout?

803