Hi Experts , Is data will get store some where in db when we use Indexed view ? or will it store only index ?

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  March 23, 2015 at 2:33 am

  #302333

  HI Experts i have a question ,

  Is data will get store some where in db when we use Indexed view ? or will it store only index ? even tough i have read many articles on this i could not get correct answer!!! will Indxed views store data in DB if yes where it stores? if not then how index created and on what basis?

  Regards,

  Ravi 🙂

• roger.price-1150775

  Default port

  Points: 1458

  More actions

  March 23, 2015 at 4:28 am

  #1785644

  Indexed views store data in the database.

  https://technet.microsoft.com/en-us/library/ms187864(v=sql.105).aspx

• Grant Fritchey

  SSC Guru

  Points: 398872

  More actions

  March 23, 2015 at 7:31 am

  #1785692

  It's stored as a clustered index, so there is data stored within the database.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning