Indices

Поиск
Список
Период
Сортировка
От sharmad@goatelecom.com
Тема Indices
Дата
Msg-id 3c1586d6.6d0.0@punweb01
обсуждение исходный текст
Ответы Re: Indices  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
What happens if you delete a row containing a BLOB?  (Terrence Brannon <metaperl@mac.com>)
how could a foreign key ever be NULL?  (Terrence Brannon <metaperl@mac.com>)
Список pgsql-sql
Hi,
Having to manny indices to a table,does it effect the performance of a table.Like
a table having following structure

Name :       First name,      Second Name,      Third name,      Age,      Address.

Is it good here to have multiple indices like on only first name, only second
name,only third name and all other combination of first ,second and third name
or the performance increases when we have only 1 indice of all first ,second
and third name
Thanks
-Sharmad


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

Предыдущее
От: Andrew Bell
Дата:
Сообщение: Re: [NOVICE] Can anybody help me with SQL?
Следующее
От: "Ivan Manuel Andrade Muñoz"
Дата:
Сообщение: postgresql v 7.1.3 error