-
User Defined Better than Stored Proceudre!!!
Hi everyone, this might be a repost but its a different topic altogether.
I have done the following.
I have a table which contains referenec keys to 3 other tables.
from eternity we are taught that stored procedure are better.
agreed.
now why wud this happen.
If i make a stored procedure ,sp_A
whose only statement is
select A,B,C from tableX innerjoin table Y innerJOin tableZ
assume the above statement is correct with reference to joins and a,b,c are values from table X, tably Y and tableZ respectively.
Now if i were to copy the same above stament and make a user defined function which returns a table
i will call it fn_A
now i run them in the query analyzer in a batch and see the execution plan.
here is the surpirsing thing
the stored proecure relatiev cost is 85.32% and the cost of the user defined function is 14.68%.
Shouldnt be the opposite way???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|