delete with index scan

Поиск
Список
Период
Сортировка
От
Тема delete with index scan
Дата
Msg-id 200411300955.iAU9twV8015258@mail2.atl.registeredsite.com
обсуждение исходный текст
Ответы Re: delete with index scan  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
I have a table t1 with a primary key column pkey, and a table t2, with a primary key column pkey. Is there a way to
makethe following delete use the indexes? 

delete from t1 where pkey in (select pkey from t2);

NOTICE:  QUERY PLAN:

Seq Scan on t1 (cost=0.00..6616238.99 rows=660239 width=6)
  SubPlan
    ->  Seq Scan on t2 (cost=0.00..20.00 rows=1000 width=8)

EXPLAIN


thanks,
Sally

------------------------------------------
Sally Ruggero
Software Development

North Electric Company, Inc.
6131 Falls of Neuse Road, Suite 205
Raleigh, NC 27609

Office: (919) 341-6009
Fax:    (919) 341-6010

Email: sally.ruggero@northelectriccompany.com


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

Предыдущее
От: Bill Harris
Дата:
Сообщение: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Следующее
От: "Joolz"
Дата:
Сообщение: Re: change natural column order