i have a view with more than 1,00,000 rows,

will there be any performance improvement while SELECTing from the query if i create a clustured index on the view..

am new to creating indexes, and am not sure whether creating a clustured index on the view will create any performance issues, when the data in the base table(s) are modified..


pl discuss