partial indexing in sql server

[ZiggyShort]

Can you implement partial indexes on a table?
Also can you index fields in a view?
I have a table with self-referential parent/child relationships, and I only wish to index the 'parent' rows. Would be an overhead to create an index on the whole table, when only a small subset of all rows require an index.

[ck9663]

No, I don't think you can partially index a table. How big is it?

For creating and indexed view, read this

-- CK