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

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.