Re: oracle table view and index

From: <nasof_at_hotmail.com>
Date: Tue, 21 Jul 1998 18:57:53 GMT
Message-ID: <6p2obi$3jq$1@nnrp1.dejanews.com>

Try to think of a view as nothing more than an alias for an SQL statement. It is not a physical object (like a table.) It is just a convenient way of storing an SQL statement in a logical manner. All indexes, primary keys, etc apply to that view as if you had just issued the SQL statement against the tables it affects.

In other words, yes it will use the indexes already on that table(s).

I hope this makes sense.
-Frank

In article <6p2g2b$p0d$1_at_nnrp1.dejanews.com>, john2335_at_my-dejanews.com wrote:
> When a table view was created, does indexes on that table
> needs to be recreated for that view or would it use the
> indexes that is on the table
>
> thanks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 21 1998 - 13:57:53 CDT