Re: indexed views now exist in Microsoft SQL Server 2000

In article <3937767D.2BBD0891_at_hp.com>, Ruud de Koter <ruud_dekoter_at_hp.com> writes
>Hi,
>
>Lewis Bruck wrote:
>>
>> I can't provide complete details, but I can answer your questions.
>>
>> 1. An indexed view has a complete materialization of all of the columns in
>> the view. Therefore an lookup of a row in the view does a single seek into
>> the index, not multiple seeks into the base table.
>>
>
>Is it too rash to conclude that an indexed view is therefore no longer
>a view but a table? In other words: is MS once again trying to change
>the meaning of a generally accepted term into the opposite?

It probably is too rash. As I understand it MS are doing exactly what Oracle did, and if both of those companies call it a view and their users call it a view then I'd say that it's generally accepted to be a view.

-- 
Bernard Peek
bap_at_shrdlu.com
bap_at_shrdlu.co.uk
bap_at_shrdlu.org.uk