materialized view equivalent ?

Hi,
Oracle query :
create materialized view view1 as select *from test
Is there any equivalent for the above query in SQL Server (specifically for "materialized views")
Please advice,
Thanks,
SamNot yet, at least not yet officially ;)|||Oracle query :

create materialized view view1 as select *from test


OK, I'll bite. What in the world is a materialized view? :confused:

It's not pulling a rabbit out of a hat, is it?|||Check out Indexed Views (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/IndexedViews.asp). They aren't quite the same as materialized views (unless you can index every column), but they get PFC (within a Pentium Floating-point Calculation) of a materialized view.

-PatP|||Thanks Pat!|||PFC (within a Pentium Floating-point Calculation) that's funny!!!|||that's funny!!!Only if you have the background to appreciate the joke. Most people today (even the geeks) wouldn't have a clue why we think it is funny.

-PatP|||it's funny on two completely different levels

first, it actually stands for "pretty darned close"

second, well, i won't spoil it for ya :)

remember the bug in the windows 3.1 calculator? i still have that executable somewhere...|||Fubar... and Darned close at that!

Heck, I remember the original problems with die 510 of the P-60 (the one that incorporated the 80387 FPU onto the 81587 CPU to produce the first "single chip" CPU/FPU in the Intel line). It was the first chip that we knew of that had what Andy later called the "floating-point anomoly".

I don't think that the bug you are refering to was caused by software (although the 3.1 calculator had plenty of those too). I think that was a math problem that was a manifestation of the FPU problems on the early Pentium chips. If so, the problem hit anything doing Floating Point math, including Excel, 1-2-3, Calc-star, etc. It also caused havok with Autocad and other related CAD software.

-PatP