RE: Views and Indexes

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Vern:

This seems at least somewhat counter to the idea that the SELECT statement in a 
view is executed whenever the view is opened. I've seen evidence that it is 
re-executed in some way, but this adds a definite twist somewhere in there.

Hmmm, indeed.

Tom Liotta

midrange-l-request@xxxxxxxxxxxx wrote:

>   5. RE: Views and Indexes (Vern Hamberg)
>
>While digging around I found the following intriguing statement from the
>SQL Reference:
>
>Adding a column has no cascaded effects to SQL views or most logical files.
>For example, adding a column to a table does not cause the column to be
>added to any dependent views, even if those views were created with a
>SELECT * clause.
>
>So a SELECT *, which means all columns, is limited to the columns defined
>at the time the view was created. This is similar to the typical behavior
>of logicals that do not break if you add a column to the underlying physical.
>
>Hmm!
>Vern

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com



__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp