Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-05-21 : 02:28:15
|
| Given qry is exist qry to chk duplication . it takes so time ( 35 min) check , becoz table has 3.5 lak records .to improve performance hot change this qry .i can say only count(*) can be removed from select list alone. anyother suggestion pls. QRY=========SELECT A, B, C, count(*)FROM TABLEGROUP BY A, B, CHAVING COUNT(*)>1 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-21 : 02:46:08
|
| What are indexes present in your table? |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-05-21 : 03:23:00
|
| no index on this table , it has 1000 columns , i am planning to put non cluster index on this 3 column .. becoz this three uses in most of the joins. |
|
|
|
|
|
|
Duplication qry performance