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...

How we say that PreparedStatment is Precompiled? where it
will be compiled?

Answer Posted / natraj

Hi,
In parsings there are two types.One Hard Parsing and second
is softparsing. Firt time hard parsing will happen.That
means wheather this query is syntatically correct or not +
what is the table name,no of cols,what are the index for
that table,any sequences and foreign key related details
etc. , and firt time only hard parsing and after that it is
going to cache it at database side only,from next time
onwards only soft parsing that means only specified record
values it will retrive.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between odbc and jdbc?

983


What is an SQL Locator?

1065


Give steps to connect to the db using jdbc?

983


Name the method, which is used to prepare a callablestatement.

882


What is a jdbc driver and how many jdbc drivers are available?

993


Why prepared statements are faster?

911


How to retrieve warnings in jdbc?

957


Why “no suitable driver” error occurs?

1031


How can we store and retrieve images from the database?

924


How can I retrieve a String or other object type without creating a new object each time?

1155


Which type of driver is unique in jdbc?

942


How can you make the connection using jdbc?

998


What are types of jdbc drivers?

959


How data can be inserted into long row column of database?

2124


How can you know about drivers and database information ?

973