In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp;
- 5 Answers
- 21729 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
In SQL Server 2000:
-------------------
A DISTINCT and GROUP BY usually generate the same query
plan, so performance should be the same across both query
constructs. GROUP BY should be used to apply aggregate
operators to each group. If all you need is to remove
duplicates then use DISTINCT. If you are using sub-queries
execution plan for that query varies so in that case you
need to check the execution plan before making decision of
which is faster.
Example of DISTINCT:
--------------------
Query:
select DISTINCT Book_Title,COUNT(*) from bookdetails
Answer:
Server: Msg 8118, Level 16, State 1, Line 1
Column 'bookdetails.Book_Title' is invalid in the select
list because it is not contained in an aggregate function
and there is no GROUP BY clause.
Example of Group By:
--------------------
Query:
select Book_Title,COUNT(*) from bookdetails group by
Book_Title
Answer:
ASP 1
C 1
C++ 1
Oracle 1
SQL Server 1
VB.Net 3
Visual Bsic 1
In this Answer, the VB.NET is Duplicate, it having this
table in 3 times.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the process of normalising?
What is sql service broker?
What are the joins in sql server? : sql server database administration
How to convert binary strings into integers in ms sql server?
Do you know exporting and importing utility?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
what is checksum in sql server.........???
Differentiate between SQL and ORACLE joins and write their syntax.
What is the difference between Triggers and Stored Procedure?
Working with TLogs
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
when you create a database how is it stored? : Sql server database administration
Explain comment on transactions?
What is data source document?
Where the sql logs gets stored?
