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

What is the Query Optimizer. How you optimize your qeury.

Answer Posted / bipin yadav

Query Optimizer is means how to imrprove the perfomance of
the query,to this we have to extract the explain plan of
that quey usin the set option on the SQL PLUS,using the
commond "SET AUTOTRACE TRACE EXP" we can see the query
cost....:-)

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1152


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2306


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1206


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2588


Could you please let me know the interfaces in OM / FA??

2339


What is auto invoicing? Explain : oracle accounts receivable

1167


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2333


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1204


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2125


What are different types of receipt reversals ? Explain them : oracle accounts receivable

1319


HOW TO SPOT AHIERARCHY?

2345


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1410


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2109


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1345


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2148