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
- 21685 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
Define Unique Key?
Explain what are partitioned views and distributed partitioned views?
What is the recovery model?
What is the difference between substr and charindex in the sql server?
What are different types of replication in sql server?
What is dml command?
what are different types of raid configurations? : Sql server database administration
What are different types of raid levels?
Which trace flags are enabled in sql server?
Why de-normalization required?
Can we create clustered index on composite key?
What stored procedure would you use to view lock information?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Is resultset an interface?
Explain about extended stored procedure?
