Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23750 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / hitesh kumar vyas s
Performance wise Distinct is more effective than group by.
Since in group by it has to group and then provide the
result but this is not the case in distinct
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
Does partitioning improve performance sql server?
Explain what is dbcc?
Explain various data region available in ssrs with their use?
How network traffic be reduced by using the stored procedure?
What is a partitioned view?
what is the system function to get current user's user id? : Sql server database administration
Explain Reporting Life Cycle?
what's the difference between a primary key and a unique key? : Sql server database administration
how you can list all the tables in a database?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is @@rowcount in sql?
Can you explain about buffer cash and log cache in sql server?
How do I create a partition table in sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
