Re: Optimization of this SQL sentence (SOLVED)

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Optimization of this SQL sentence (SOLVED)
Дата
Msg-id 20061018191901.GO85041@nasby.net
обсуждение исходный текст
Ответ на Re: Optimization of this SQL sentence (SOLVED)  (Ruben Rubio <ruben@rentalia.com>)
Список pgsql-performance
On Tue, Oct 17, 2006 at 12:25:39PM +0200, Ruben Rubio wrote:
> First of all I have to say that I now the database is not ok. There was
> a people before me that didn't do the thinks right. I would like to
> normalize the database, but it takes too much time (there is is hundred
> of SQLs to change and there is not enough technical resources). Also,
> datacolumns in some places has same names, but the data that is stores
> has different usages.

FWIW, things like views and rules make those transations a lot easier to
tackle.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Optimization of this SQL sentence
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Optimization of this SQL sentence