Viewing 2 posts - 1 through 3 (of 3 total)
Thanks for your reply Fitz. That's what I got for posting without testing. That means that CTE for deletes have not much value. I can rewrite it to make it...
Rudolf van der Heide
Data warehouse architect
Currently working in a MSSQLServer environment
15 years experience in design and development of data warehouses and ETL,
and in ETL and data warehouse performance tuning, in both MSSQLServer and Oracle.
April 5, 2012 at 5:30 am
I will try to explain, even having no time to set up a test.
A delete can use indexes to find the deletion key, especially when it is a small...
Rudolf van der Heide
Data warehouse architect
Currently working in a MSSQLServer environment
15 years experience in design and development of data warehouses and ETL,
and in ETL and data warehouse performance tuning, in both MSSQLServer and Oracle.
April 5, 2012 at 2:47 am
Viewing 2 posts - 1 through 3 (of 3 total)