Originally posted by Vishaalc
Some are fast refresh others cannot be since they have complex queries associated with them.
If you want 'almost real time' data, maybe you should rethink these complex queries.
That's what I did, I have fast refresh on all tables in a under 2 minutes period. Because of not using complex queries I have 2 tables with more data than I need, but in my environment this is not a problem (of security or integrity). Even with excessive data being refreshed, it's faster, it's putting less overhead on network and less work on master database than it would with full refresh.