Re: [JDBC] [PERFORM] is a good practice to create an index on the

Поиск
Список
Период
Сортировка
От Edoardo Ceccarelli
Тема Re: [JDBC] [PERFORM] is a good practice to create an index on the
Дата
Msg-id 408ED3E2.802@axa.it
обсуждение исходный текст
Ответ на Re: [JDBC] [PERFORM] is a good practice to create an index on the  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: [JDBC] [PERFORM] is a good practice to create an index on the  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-admin
I am going to use them as primary key of the table, so I'll surely need
them unique :)
thank you for you help
Edoardo

Dave Cramer ha scritto:

>Edoardo,
>
>Are you using them for referential integrity? If so you would be wise to
>use sequences instead.
>
>Christopher: yes you are correct, I wasn't sure if that is what he was
>doing.
>
>Dave
>On Tue, 2004-04-27 at 11:01, Christopher Kings-Lynne wrote:
>
>
>>>AFAIK, oids aren't used for anything internally, so duplicates don't
>>>really matter. Besides, what would you do about duplicate oid's ?
>>>
>>>
>>If he's using them _externally_, then he does have to worry about
>>duplicates.
>>
>>Chris
>>
>>
>>
>>!DSPAM:408e75e0137721921318500!
>>
>>
>>
>>

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

Предыдущее
От: "Eduardo Naschenweng"
Дата:
Сообщение: Optimizer choosing smaller index instead of right one
Следующее
От: jseymour@LinxNet.com (Jim Seymour)
Дата:
Сообщение: Re: Recover data