How to force PostgreSQL using an index

Поиск
Список
Период
Сортировка
От Daniel Caune
Тема How to force PostgreSQL using an index
Дата
Msg-id 1E293D3FF63A3740B10AD5AAD88535D2019091DC@UBIMAIL1.ubisoft.org
обсуждение исходный текст
Ответы Re: How to force PostgreSQL using an index  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA" style="font-size:
10.0pt;font-family:Arial">Is there a way to force PostgreSQL using an index for a SELECT statement?  I just want to
confirmthat the index PostgreSQL decides to use is better than the index I supposed PostgreSQL would use (I already
analyzethe table).</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">Regards,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">--</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Arial">Daniel CAUNE</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Arial">Ubisoft Online Technology</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial">(514) 4090 2040 ext. 5418</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font
face="TimesNew Roman" size="3"><span lang="EN-CA" style="font-size:12.0pt"> </span></font></div> 

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

Предыдущее
От: Maciej Piekielniak
Дата:
Сообщение: Re: alter table
Следующее
От: "Owen Jacobson"
Дата:
Сообщение: Re: How to force PostgreSQL using an index