Home » SQL & PL/SQL » SQL & PL/SQL » Performance Tuning
Performance Tuning [message #220305] Tue, 20 February 2007 03:10 Go to next message
rao_papa
Messages: 6
Registered: December 2006
Location: Hyderabad
Junior Member
Is there any precaution to take before going to write a query
Re: Performance Tuning [message #220319 is a reply to message #220305] Tue, 20 February 2007 04:16 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I always like to make sure my chair provides back support, my monitor is at the correct height, and that I've got a fresh cup of coffee.

On a more serious note - could you explain what sort of answer you are expecting?

{spelling}

[Updated on: Tue, 20 February 2007 04:25]

Report message to a moderator

Re: Performance Tuning [message #220328 is a reply to message #220305] Tue, 20 February 2007 05:25 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
Reported By: rao_papa On: Tue, 20 February 2007 05:43 In: SQL & PL/SQL » SQL & PL/SQL Newbies » Performance Tuning
Reason Any one will write a query that is not a matter...that query should be good in performance wise...it should not give any performance problem further ...

Again, apply some rationale before posting the question and reporting it. Out of a possible million precautions one would take, which particular one are you talking about?
Just go through this section on performance tuning manual.
You can understand how vague your question could be.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/part4.htm#g996847

[Updated on: Tue, 20 February 2007 06:06]

Report message to a moderator

Previous Topic: Using dynamic table and column names in a stored procedure
Next Topic: Difference between time and timestamp?
Goto Forum:
  


Current Time: Fri Dec 06 18:22:04 CST 2024