Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Please explan Why static query is more faster than dynamic
query ?

Question Posted / uma

Answer Posted / uma

In dynamic SQL the SQL statement is prepared each time
before the Run time.But this not the case with static SQL
it ll be stored in shared SQL area and this will refered if
same Query is used again.So static ll be faster

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is better Oracle or MS SQL? Why?

4920

Explain the use of owner option in exp command.

1037

What are the ansi data types supported in oracle?

942

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2351

How to run create database statement?

1022

How to get execution statistics reports on query statements?

1078

What is a procedure in oracle?

1175

How to start your 10g xe server from command line?

1067

How to use "while" statements in oracle?

1314

How to return top 5 rows in oracle?

1051

Can we write dml statement in function in oracle?

1074

Differentiate between translate and replace?

1101

Is it possible to split the print reviewer into more than one region ?

2272

What are the tools for Oracle ?

1053

What is Segment Advisor in Oracle?

1099