is a good practice to create an index on the oid?

Поиск
Список
Период
Сортировка
От Edoardo Ceccarelli
Тема is a good practice to create an index on the oid?
Дата
Msg-id 408D3AE8.5020006@axa.it
обсуждение исходный текст
Ответы Re: [JDBC] is a good practice to create an index on the oid?  (Dave Cramer <pg@fastcrypt.com>)
Re: [PERFORM] is a good practice to create an index on the oid?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-admin
I am using the oid of the table as the main key and I've found that is
not indexed (maybe because I have declared another primary key in the table)

it is a good practice to create an index like this on the oid of a table?
CREATE INDEX idoid annuncio400 USING btree (oid);


does it work as a normal index?

Thank you
Edoardo

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

Предыдущее
От: JC Jan Christensen
Дата:
Сообщение: INITDB-error - end-of-copy marker error
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: [JDBC] is a good practice to create an index on the oid?