Re: Query using SeqScan instead of IndexScan

Поиск
Список
Период
Сортировка
От chris smith
Тема Re: Query using SeqScan instead of IndexScan
Дата
Msg-id 3c1395330604011650r61c793a7td3e8be58ab023c7b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query using SeqScan instead of IndexScan  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Query using SeqScan instead of IndexScan  ("chris smith" <dmagick@gmail.com>)
Список pgsql-performance
On 4/2/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Sat, Apr 01, 2006 at 11:23:37AM +1000, chris smith wrote:
> > On 4/1/06, Brendan Duddridge <brendan@clickspace.com> wrote:
> > > Hi Jim,
> > >
> > > I'm not quite sure what you mean by the correlation of category_id?
> >
> > It means how many distinct values does it have (at least that's my
> > understanding of it ;) ).
>
> Your understanding is wrong. :) What you're discussing is n_distinct.

Geez, I'm going well this week ;)

Thanks for the detailed info.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: [Solved] Slow performance on Windows .NET and OleDb
Следующее
От: "chris smith"
Дата:
Сообщение: Re: Query using SeqScan instead of IndexScan