Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 8.1.6 materialized view rowid vs. primary key?
oracle 8.1.6 on solaris. the problem is this:
i have a materialized view that has refresh_method = rowid. when i issue a query that contains that snapshot (and other tables joined to it), explain plan shows a merge join cartesian and full table scan on the snapshot, even tho it should be able to do index scans. i recreated the snapshot exactly the same way, except refresh method = primary key, and voila, the query plan was what i expected. is there a reason for this? all the indexes were the same for both tables (including an intermedia full-text index).
i'm not talking about the underlying query that defines the snapshot, i'm talking about queries that involve the snapshot.
thanks in advance for any info.
Sent via Deja.com
http://www.deja.com/
Received on Wed Dec 27 2000 - 13:56:23 CST