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

What is a cursor in oracle?

1159

How to apply filtering criteria at group level in oracle?

1025

How to save query output to a local file?

1004

interview questions with answer for cts

2569

How to use an explicit cursor without open statements?

1041

What is a nested table?

1037

What are a cluster and non-cluster index?

996

Which is better Oracle or MS SQL? Why?

6343

Explain cascading triggers.

1057

How to connect to oracle using service name instead of sid?

995

Difference between the “verify” and “feedback” command?

1343

how can we store any pdf file in oracle

2147

What is proxy method?

960

What are the uses of Database Trigger ?

1686

What are the different types of modules in oracle forms?

989