OraFAQ Forum: Performance Tuning » SQL Tuning

Home » RDBMS Server » Performance Tuning » SQL Tuning - Distinct Vs Group by

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Tuning - Distinct Vs Group by [message #220561]

Wed, 21 February 2007 05:01

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

Hi all,
I am having a table say
e(empname, phone) where one emp can have more then one phone number.
To get the distinct empname from the table I can use following two queries -
1. select distinct empname from e;
2. Select empname from e group by empname;

Which one is more efficient and why?
With regards
Amit Nanote

Report message to a moderator