Re: Views- Advantages and Disadvantages

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Views- Advantages and Disadvantages
Дата
Msg-id 46422E18.1040808@commandprompt.com
обсуждение исходный текст
Ответ на Re: Views- Advantages and Disadvantages  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-general
Dann Corbit wrote:
>> -----Original Message-----
>> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
>> owner@postgresql.org] On Behalf Of Ashish Karalkar
>> Sent: Wednesday, May 09, 2007 1:36 AM
>> To: Andrej Ricnik-Bay; Ron Johnson
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] Views- Advantages and Disadvantages
>>
>> Thanks All for your replies,
>>
>> But then dont we have any disadvantage of using View???
>
> Views can hide important information from the optimizer (especially
> index information).

I don't believe that is true in PostgreSQL's case.

Joshua D. Drake

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


В списке pgsql-general по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: User restrictions
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Views- Advantages and Disadvantages