Re: [SQL] quest:optimization with indexes

Поиск
Список
Период
Сортировка
От Clayton Cottingham
Тема Re: [SQL] quest:optimization with indexes
Дата
Msg-id 37B1B641.5AD0DC0C@smartt.com
обсуждение исходный текст
Ответ на quest:optimization with indexes  (Clayton Cottingham <drfrog@smartt.com>)
Ответы Re: [SQL] quest:optimization with indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
thanks all, i actually was able to piece this all together last night!

what i did was create another column that had a nextval sequence
and im using that as an index, instead of over a thousand sec i am now getting
a index with 2 sec

thanks for all those 'like' tips i was wonderinng, would using regex be the
same as far as the indexing rules go?






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

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: [SQL] quest:optimization with indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] quest:optimization with indexes