Re: More pain and sufferring with Tropashko's materialized path...

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 18 Sep 2003 10:21:29 -0700
Message-ID: <a264e7ea.0309180921.51b4de35_at_posting.google.com>

>> but further research leads me to believe this isn't such a good
idea anyway, because apparently, with MS-SQL at least, applying a UDF per row tends to screw up query optimisation on large trees (something to do with serialization). <<

The UDF causes SQL Server to revert to row at a time processing rather than set oriented processing. It is a big hit, as you found out. Received on Thu Sep 18 2003 - 19:21:29 CEST

This message: [ Message body ]
Next message: Mikito Harakiri: "Re: More pain and sufferring with Tropashko's materialized path..."
Previous message: Mikito Harakiri: "Re: Jan's well-defined view updates definition"
Maybe in reply to: Robin Tucker: "More pain and sufferring with Tropashko's materialized path..."
In reply to Robin Tucker: "Re: More pain and sufferring with Tropashko's materialized path..."
Next in thread: Mikito Harakiri: "Re: More pain and sufferring with Tropashko's materialized path..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message