Table hints in the definitions of indexed views are ignored in 80 compatibility mode and are not allowed in 90 mode or later. ...

Table hints in the definitions of indexed views are ignored in 80 compatibility mode and are not allowed in 90 mode or later. When running in 90 mode or later, table hints must be removed from the definitions of indexed views. When running in 80 mode, no action is required. In either mode, it is recommended that the application be tested to make sure it performs as expected when creating, updating, and accessing indexed views, including the matching of queries to indexed views.