Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: More pain and sufferring with Tropashko's materialized path...

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@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 - 12:21:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US