Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Materialised Views - Views / Opinions ??

Status
Not open for further replies.
nchapman

nchapman

Programmer
Aug 9, 2002
16
0
0
GB
Wondered if anyone out there has any views/opinions on Materialised Views.

Anyone had any bad experiences with them ?

Anyone got any advice, things to look out for ?
 
Sort by date Sort by votes
Well, aggregatefunctions with refresh on commit are kind of a pain (dunno if thats fixed in the latest patch), but MVs are nice for "mirroring" a table.

Stefan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PMSLIC
  • Locked
  • Question
Materialized Views - which comes first? 1
Replies
1
Views
26
taupirho
taupirho
AlStl
  • Locked
  • Question
execute multiple views within a single stored procedure
Replies
4
Views
46
sem
sem
jwa6
  • Locked
  • Question
views missing table fields 2
Replies
13
Views
59
jwa6
jwa6
johnherman
  • Locked
  • Question
Oracle views and performance 1
Replies
2
Views
13
jimbopalmer
jimbopalmer
mikedaruke
  • Locked
  • Question
triggers on views
Replies
4
Views
21
Dagon
Dagon

Part and Inventory Search

Sponsor

Back
Top