|
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 would not need to spend
time checking multiple tables to determine the table to which each column
belongs.
Is this still a valid rule?
Does this apply to statements in PL/SQL procedures/packages? Or are
they different, because they are checked at compile time?
-a
|
- Qualifying columns to improve performance? Arn Klammer
- Re: Qualifying columns to improve performance? Arn Klammer
- Re: Qualifying columns to improve performance? Connor McDonald
- RE: Qualifying columns to improve performance? Steve Adams
- Re: Qualifying columns to improve performance? Oliver Artelt
- RE: Qualifying columns to improve performance? Li, Xiangli
