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

can you explain performance tunning in oracle(sql,PL/SQL)

Question Posted / sudipta santra

Answer Posted / sudipta santra

First u need to take explain plan of the proposed query then
you can identify for which join condition is costlier. By
watching this then you can modify the condition logic of the
query.

There are so many logic for make a query tune.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to loop through data rows in the implicit cursor?

1064

Define oracle database

1038

What are the different windows events activated at runtime ?

2893

What are the uses of synonyms?

1133

How to run create database statement again?

1143

How to load a large xml file?

1044

How to define a cusotmer as a supplier in ORACLE R12

2224

WHAT IS ecc 6.0

2145

Explain the dml?

971

How do I learn what codesets are available in oracle?

1032

What is a package ? What are the advantages of package ?

1085

How do you store pictures in a database?

997

What is system tablespace?

1088

What are the differences between char and varchar2 in oracle?

1161

How do I find the database name in oracle?

1028