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

Can we save images in a database and if yes, how?

1065

What is a tns file?

997

Why packages are used in oracle?

1069

How to concatenate two text values in oracle?

1114

Why do we need oracle client?

954

Explain the importance of .pll extension in oracle?

1013

What is integrity and what is constraint??Explain with example

2284

How do I start tns listener?

1047

How to define a procedure inside another procedure?

1024

what is port in oracle? how is it related to database application.

1949

what are actual and formal parameters?

1104

How to connect to a remote server?

1128

How to run the anonymous block again?

1132

How to use null as conditions in oracle?

1084

What is bulk copy or bcp in oracle?

1124