Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: 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,
    Sam

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Not yet, at least not yet officially
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Oracle query :

    create materialized view view1 as select *from test
    OK, I'll bite. What in the world is a materialized view???

    It's not pulling a rabbit out of a hat, is it?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check out Indexed Views. 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

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Thanks Pat!

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Pat Phelan
    PFC (within a Pentium Floating-point Calculation)
    that's funny!!!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r937
    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

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •