Re: : Postgres IX

Поиск
Список
Период
Сортировка
От Shaun Clements
Тема Re: : Postgres IX
Дата
Msg-id 100F78F2B203444BB161BBA7077FF6131CD9D4@srldbexc003.relyant.co.za
обсуждение исходный текст
Ответ на : Postgres IX  (Shaun Clements <ShaunC@relyant.co.za>)
Ответы Re: : Postgres IX
Список pgsql-general
Дерево обсуждения
Or better yet.
Can anyone explain the use of indexing, effecting the performance of select query, using INDEXED columns, and non indexed columns.
 
I.E.
 
Select from table where column1 = 'xxxx' and column2 = 'xxxxx'
 
WHERE COLUMN1 is indexed, and COLUMN2 isnt.
 
Thanks in advance
 
A {FONT-FAMILY: verdana; TEXT-DECORATION: none } A:active {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:link {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:visited {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:hover {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: underline } .small_text {FONT-SIZE: 9px; COLOR: #003366; FONT-FAMILY: verdana } Kind Regards,
Shaun Clements
 

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