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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2011-10-14 : 08:44:17
|
| I have a view that uses Group By. This view is also used in an insert statement. I would think if the Group By does not match the PK or Index on the table it is inserting, that this would cause major overhead?Thanks for all comments...R/P |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-14 : 09:09:18
|
| if group by is not on pk columns it would cause pk violations if you've multiple columns per pk column group------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Group By in Views