| mohamed riaz |
Posted: Dec 22, 2007 05:31:43 PM |
Total Post: 91
Joined: Sep, 2006
|
Dear all,
I attended one interview, they are asked How will you Tune SQL QUERY?
Please explain if any one known. Pls explain step by step.
Thanks
Riaz |
|
|
Mohammed Taj |
| Posted: Dec 23, 2007 08:12:50 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
sql tuning:
is not small topic for sql tunning you have good/more knowledge about sql and tuning.
anyway keep in mind below thing which i know for sql tuning.
1. up to date statistics
2. proper indexing
3. predicate (<=,<,>= etc)
4. join method ( nested loop, hash join , sort merge join etc)
5. optimizer mode : "cbo" or "rbo".
above thing you have to consider when you tune sql statement through generate execution plan.
start with here http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/part4.htm#g996847
|
|
|
|
|
mohamed riaz |
| Posted: Dec 24, 2007 06:55:56 AM | |
|
Total Post: 91
Joined: Sep, 2006
|
Dear Taj salam,
Can you explain what is the main features of oracle 9i ?
Regards
Mohamed Riaz
91205511
|
|
|
|
|
Mohammed Taj |
| Posted: Dec 24, 2007 08:17:39 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Did you check new features oracle 9i.
http://tahiti.oracle.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |