Re: Performance of count(*) on large tables vs SQL Server

Поиск
Список
Период
Сортировка
Искать
От
PFC
Тема
Re: Performance of count(*) on large tables vs SQL Server
Дата
Msg-id
opslite4tuth1vuj@musicbox
Ответ на
Performance of count(*) on large tables vs SQL Server (Andrew Mayo)
Список
Дерево обсуждения
Performance of count(*) on large tables vs SQL Server Andrew Mayo <ajmayo@kohuconsulting.com>
Re: Performance of count(*) on large tables vs SQL Server Shridhar Daithankar <ghodechhap@ghodechhap.net>
Re: Performance of count(*) on large tables vs SQL Server Stef <stef@ummon.com>
Re: Performance of count(*) on large tables vs SQL Server PFC <lists@boutiquenumerique.com> 


> clause will be a cheap query  - and use it to test if
> a table is empty, for instance. (because for
> Oracle/Sybase/SQL Server, count(*) is cheap).

	To test if a table is empty, use a SELECT EXISTS or whatever SELECT with  
a LIMIT 1...
В списке pgsql-performance по дате отправления
Предыдущее
От: Stef
Дата:
Следующее
От: Alex Turner
Дата:
FAQ