What happens when I create an index on a view? Are there any benefits versus using a table with indexes? <p>From what I understand the data will be "persisted" (physically stored, not just retrieved when i need it). Is this correct? </p> <p>If so what would be the advantage of using an indexed view versus just using a table?</p>