128 reputation
5
bio website
location Maryland
age 39
visits member for 1 year, 7 months
seen Dec 26 '12 at 17:04

Still a physicist at heart.


Jul
28
awarded  Popular Question
Dec
14
comment Performance tuning a cascading delete with many foreign keys
Thanks for the very detailed answer. For the cases where there is an index scan and a table spool below an inner join, these are mostly cases where the PK Index of a child object (the index) is being merged with the parentId (the table spool) - would it be appropriate to add the parentId to the existing index as an included column? Or better to create a new index around the parentId?
Dec
14
awarded  Scholar
Dec
14
accepted Performance tuning a cascading delete with many foreign keys
Dec
14
awarded  Supporter
Dec
14
comment Performance tuning a cascading delete with many foreign keys
fixed permissions on google doc, sorry.
Dec
14
revised Performance tuning a cascading delete with many foreign keys
added 132 characters in body
Dec
14
awarded  Student
Dec
14
awarded  Editor
Dec
14
revised Performance tuning a cascading delete with many foreign keys
added 15 characters in body
Dec
14
asked Performance tuning a cascading delete with many foreign keys