Two Questions on Views:

1. Is there a performance hit when using Views that reference other Views because it seems that once a view returns its rows and then another view acts upon that record set, then that record set would have no indexes, thus making query execution slow down.

2. The project lead wants all tables to have a corresponding view created, "Select * from tablename" so that they can write inline SQL statement from their VB app containing filteragainst that view (with some criteria.) Wouldn't it be faster if they ran those queries directly against the table directly.