Title: RE: Qualifying columns to improve performance?
-Original Message-
From: Arn Klammer [SMTP:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 10:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Qualifying columns to improve performance?
At a course some years ago, we
Why not try the two (one with qualifiers and one
without) and trace each - on a freshly started
database...
See how much additional recursive sql occurs (if any)
hth
connor
--- Arn Klammer [EMAIL PROTECTED] wrote:
At a course some years ago, we were told that in
join statements, we should
Hi Arn,
There may be good reasons for explicitly qualifying all column references, but
performance is not one of them, at least under Oracle 8i. I've just done some
tests and there is absolutely no difference in the number of dictionary cache
gets required during the parse, and no measurable
Hi,
you should better reuse your parsed statements
oli
[EMAIL PROTECTED] wrote
At a course some years ago, we were told that in join statements, we
should
qualify ALL our column names with the appropriate table name, not just
those that may be ambiguous. The reason was that the parser