Андрей Репко wrote:
Здравствуйте Richard,
Tuesday, September 27, 2005, 2:08:31 PM, Вы писали:
sart_ma=# EXPLAIN ANALYZE SELECT alias_id FROM ma_data GROUP BY alias_id;
QUERY PLAN
---
Андрей Репко wrote:
RH> What happens if you use something like
RH>SELECT DISTINCT alias_id FROM ma_data;
sart_ma=# EXPLAIN ANALYZE SELECT DISTINCT alias_id FROM ma_data;
QUERY PLAN
-
Здравствуйте Richard,
Tuesday, September 27, 2005, 2:08:31 PM, Вы писали:
>> sart_ma=# EXPLAIN ANALYZE SELECT alias_id FROM ma_data GROUP BY alias_id;
>>QUERY PLAN
>> -
Здравствуйте Richard,
Tuesday, September 27, 2005, 1:48:15 PM, Вы писали:
RH> Andrey Repko wrote:
>>
>> I have table ma_data, that contain above 30 rows.
>>This table has primary key id, and field alias_id.
>>I create index (btree)on this field.
>>Set statistic:
>>
>> ALTER
Andrey Repko wrote:
I have table ma_data, that contain above 30 rows.
This table has primary key id, and field alias_id.
I create index (btree)on this field.
Set statistic:
ALTER TABLE "public"."ma_data"
ALTER COLUMN "alias_id" SET STATISTICS 998;
So, when I do somethin
Hello all,
I have table ma_data, that contain above 30 rows.
This table has primary key id, and field alias_id.
I create index (btree)on this field.
Set statistic:
ALTER TABLE "public"."ma_data"
ALTER COLUMN "alias_id" SET STATISTICS 998;
So, when I do something like
