Re: create index on function - why?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: create index on function - why?
Дата
Msg-id 200202170249.g1H2nDE23123@candle.pha.pa.us
обсуждение исходный текст
Ответ на create index on function - why?  (Wei Weng <wweng@kencast.com>)
Ответы Re: create index on function - why?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-sql
Due to time constraints, I do not directly answer general PostgreSQL
questions.  For assistance, please join the appropriate mailing list and
post your question:
http://www.postgresql.org/users-lounge

You can also try the #postgresql IRC channel.  See the PostgreSQL FAQ
for more information.

---------------------------------------------------------------------------


Wei Weng wrote:
> I can understand the rationale behind creating index on tables, it 
> speeds up the searching.
> 
> But what is the rationale behind creating index on a function? how does 
> it help with the database performance?
> 
> Thank you.
> 
> -- 
> Wei Weng
> Network Software Engineer
> KenCast Inc.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us root@candle.pha.pa.us                |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Troels Arvin
Дата:
Сообщение: Re: comparision chart
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Changing column constraints?