Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 index

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2004-11-05 : 03:41:31
I am using quite a few table functions which I will then insert into and then update.
While I create the table functions, is it best to use clustered and non-clustered indexes?
Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-11-05 : 05:35:50
what is a table function???

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-11-05 : 08:05:08
This has gotta be a "depends" answer

Please post some sample code and we'll take a look

Kristen
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-11-05 : 09:26:38
do you mean table VARIABLES ?

they can only have a primary key, no other indexes, so it's a moot point.

- Jeff
Go to Top of Page
   

- Advertisement -