Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, redi.

Asked: May 23, 2001 - 11:48 am UTC

Last updated: May 24, 2001 - 2:00 am UTC

Version: 8.1.7

Viewed 1000+ times

You Asked

Tom

Can briefly discuss the differences between pl/sql tuning .. sql tuning. How do they compliment each other.

Can you give me an example, where a well tuned query does not perform well due to badly written pl/sql, and vice versa.

Thank you

and Tom said...

tuning SQL is tuning SQL. SQL is a non-procedural language. You are going to be tuning a SINGLE statement.

PLSQL is a 3gl -- like C, Java, VB, etc.... Tuning it is like tuning a program (because -- it is a program).

they are just totally different.


A well tuned query will perform well regardless of the environment. It will NOT perform poorly due to poorly written code.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Lov Display Problem

Venkat, May 24, 2001 - 2:00 am UTC

Hi
Lov Columns usually display in Horizontal order. But I want to display in vertical order. Is it possible in Forms 4.5.

Thanks
By
venkat