Discussion concerning the free SQL Sentry Plan Explorer
2/21/2012 2:19:12 PM
Gokhan
Posts: 9
|
We have a filtered index on a table and a clustered index. We do a straight insert of 1000000 rows into this table, plan diagram is right, showing the right amount of rows inserted into the table but on the top statement grid the actual rows is showing the amount of rows inserted into filtered index.
I just wanted to point it out, knowing how it shows I know what to look for it now.
|
|
0
• permalink
|
2/21/2012 2:34:26 PM
Aaron Bertrand
Moderator
Posts: 57
|
Hi Gokhan, you are absolutely right, I was able to reproduce this scenario. We'll track this issue internally and I'll post back here when we have an update.
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|
2/21/2012 3:14:07 PM
Gokhan
Posts: 9
|
I guess I am going to meet you in Tampa at SQLSkills on March 6th :-) ?
|
|
0
• permalink
|
2/21/2012 3:15:55 PM
Aaron Bertrand
Moderator
Posts: 57
|
We'll be there but not me personally, no. :-)
--
Aaron Bertrand, Senior Consultant
SQL Sentry, Inc.
|
|
0
• permalink
|