Tunning question - DISTINCT or GROUP BY?
From: Miguel Pinto <j-miguel-pinto_at_telecom.pt>
Date: 17 Dec 2001 05:27:42 -0800
Message-ID: <c667c164.0112170527.74e57406_at_posting.google.com>
Date: 17 Dec 2001 05:27:42 -0800
Message-ID: <c667c164.0112170527.74e57406_at_posting.google.com>
Hi all,
What is more fast: Use select distinct or a group by clause?
Example:
select distinct a.col1, a.col2, b.col1
from tab1 a, tab2 b
where a.col1=b.col1(+);
or
select a.col1, a.col2, b.col1
from tab1 a, tab2 b
where a.col1=b.col1(+)
group by a.col1, a.col2, b.col1;
THANKS IN ADVANCE
Miguel Pinto
Received on Mon Dec 17 2001 - 14:27:42 CET