create an INDEX for a TVP in SQL 2008

Can we create an Index for TVP's(Table valued Parameters) in SQL Serve开发者_开发技巧r 2008.

please can any one give the syntax.

Thanks In advance.. Vinay K

---

You can have primary key and unique constraints, which will automatically have indexes backing them, but you're unable to declare any indexes explicitly for table types

---

If you think your query could benefit from further indexes, pretty well you'll have to copy the rows from your TVP into a temporary table (not table variable), on which you can define any indexes you want. But obviously that will add some additional overhead (in time and memory costs)