Re: Views- Advantages and Disadvantages

Поиск
Список
Период
Сортировка
От Ragnar
Тема Re: Views- Advantages and Disadvantages
Дата
Msg-id 1178701529.10736.54.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Views- Advantages and Disadvantages  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
Список pgsql-general
On mið, 2007-05-09 at 12:46 +0530, Ashish Karalkar wrote:

> I have found out some of them n are as follows, but  I want more reasons
> for not using views . I only got one

>
>  Disadvantages:

> 1)      Performance : If a view is defined by complex multitable query,then
> simple query against that view becomes a coplecated join, and it may take a
> long time to complete
>

2) UPDATES on a view are more tricky.

gnari



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: PG on Debian 4.0.x ?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Views- Advantages and Disadvantages