PL/SQL versus SQL

From: NKatwala <nkatwala_at_aol.com>
Date: 1996/05/29
Message-ID: <4oi93i$38r_at_newsbf02.news.aol.com>#1/1

Everybody,

Does anyone have any performance benchmarks comparing a PL/SQL program versus a SQL program? Can someone point us to some white papers or performance discussions between PL/SQL and SQL performance? Or some book?

If I am scanning a 36 million row table to create a consolidated 2.2 million row table, will a properly constructed PL/SQL program give me the same performance as a SQL program? How much difference will be there in performance?

The temporary space is not a problem.

Niraj Katwala

Received on Wed May 29 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: GT Cherer: "Hidden passwords..once more."
Previous message: Jeff: "SQL-PLUS script for moving indexes to separate tables space"
Next in thread: Torben Krogh Jeppesen: "Re: PL/SQL versus SQL"
Reply: pemmck_at_ibm.net: "Re: PL/SQL versus SQL"
Reply: Torben Krogh Jeppesen: "Re: PL/SQL versus SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message