Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Questions about Materialized View
Well, underneath, materialized view IS a table. As such, you can
create indexes on it as you would with a table. You can look up
user_mviews, if there is an entry with mview_name='myTable' then it is
a materialized view. Every materialized view has 2 entries in the
user_objects view - one has "MATERIALIZED VIEW" as the object_type,
the other "TABLE". A regular table has only 1 "TABLE" object_type
entry.
bombadil_at_fastmail.fm (Bombadil) wrote in message news:<eedb1e6a.0303051328.25d9bc0c_at_posting.google.com>...
> Hi,
>
> I am pretty new to Oracle :-)
>
> How do I figure out if I am querying a regular table or a materialized
> view?
> e.g.: SELECT myID FROM myTable ...
>
> Is there any SQL command to tell if "myTable" is a regular table or a
> materialize view?
>
> Can I create an index on any column of a materialized view like if it
> was a regular table?
> e.g.: CREATE INDEX ...
>
> Thanks in advance,
> Bombadil.
Received on Wed Mar 05 2003 - 20:19:25 CST