I have a table with approximately 10 million rows in it. Several queries we run against it are selecting all the rows in it where a bit column in the table is equal to 1. Naturally, I don't want to create an index on a bit field so the queries are horribly slow. I thought that the best thing to do would create an indexed view to use. I created it but even when I run a select on the view it's still scanning the underlying table. Is there an issue with creating a view this way? The index is a unique clustered one. And I've verified that the view is materialized and taking up space.