Indexing tables in user defined functions

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Indexing tables in user defined functions

SQL Server 2005 General discussion of SQL Server *2005* version only.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

July 12th, 2008, 03:38 AM

A17560127

A17560127 is offline

Registered User

Join Date: Apr 2005

Posts: 4

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Indexing tables in user defined functions

Is it possible to index tables in an user defined function? When variable tables in an UDF are getting very large and you must link this to another table, the function is getting very slow.

Old

July 21st, 2008, 03:56 AM

Peso

Peso is offline

Friend of Wrox

Join Date: May 2006

Posts: 246

Thanks: 0

Thanked 0 Times in 0 Posts

Default

No, you can't with the exception to put a primary key index on the function return table.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User-defined functions	fredh	Excel VBA	1	May 7th, 2007 10:28 AM
Portability of User Defined Functions (UDFs)	fredh	Excel VBA	0	May 3rd, 2007 06:07 PM
Number format in User Defined Functions	Moose35	Excel VBA	1	February 17th, 2005 05:23 AM
User-Defined Functions - How to recalculate?	kmoran	Excel VBA	1	October 5th, 2004 02:45 AM
user defined functions in vba	re_anu	Access VBA	2	March 3rd, 2004 01:59 PM