Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Lennart Jonsson Newsgroups: comp.databases.ms-sqlserver Subject: Indexed views availible in all versions of mssql 2012? Date: Mon, 18 Jun 2012 10:45:28 +0200 Organization: A noiseless patient Spider Lines: 10 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Injection-Date: Mon, 18 Jun 2012 08:45:28 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="bflSdaxROoSQaSvhiBWUVA"; logging-data="10975"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+P3j11H8dcg5O7xx6AnSXE" User-Agent: Mozilla/5.0 (X11; Linux i686; rv:12.0) Gecko/20120430 Thunderbird/12.0.1 Cancel-Lock: sha1:/jlurRQtkfVYGaQehl2b1cN+8ic= Xref: csiph.com comp.databases.ms-sqlserver:1127 I'm trying to determine in what versions of mssql-2012 indexed views are available, but so far I have not seen it mentioned anywhere. Oracle supports materialised views and and DB2 supports materialised query tables in there enterprise versions. Is mssql more generous in this respect, or am I just a lousy investigator? Cheers /Lennart