What are the performance benefits for using Indexed views ?
Views in SQL Server 2000 are very similar to those in previous versions with a few major exceptions when using Indexed views. When a clustered index is created on the view, SQL Server immediately allocates storage space to store the results of the view. You can then treat the view like any other table by adding additional nonclustered indexes.
Oracle have the concept of a Materialized View that give an additional performance boost by being able to have indexes built on a view