Hi,

a system I have has a table called Transactions, then a view based on that called viewTransactions and then another view based on the first view called viewTopTransactions.

Should I create indexes on the underlying table and that will speed up queries against the views? Or should I create indexes on the views? or should I index both table and views?

The queries are like this:

SELECT DISTINCT [PNRStatus] FROM [viewTransactions] ORDER BY [PNRStatus]