<[EMAIL PROTECTED]> wrote :
> Greg Obleshchuk wrote:
>>
>> So in these cases there is no benefit from creating an index on a column
>> that is INTEGER PRIMARY KEY?
>>
>
> Putting an index on an INTEGER PRIMARY KEY will make INSERT,
> DELETE, and UPDATE slower since the index must be
Thanks for clearing that up
Greg
- Original Message -
From: D. Richard Hipp
To: [EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 11:52 AM
Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index
Greg Obleshchuk wrote:
>
> So in these
Greg Obleshchuk wrote:
So in these cases there is no benefit from creating an index on a column
that is INTEGER PRIMARY KEY?
Putting an index on an INTEGER PRIMARY KEY will make INSERT,
DELETE, and UPDATE slower since the index must be maintained.
But no SELECT will ever use the index. So
- Original Message -
From: D. Richard Hipp
To: Greg Obleshchuk
Sent: Tuesday, February 10, 2004 9:29 AM
Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index
Greg Obleshchuk wrote:
>
> Select * , Product_Description.ProductName from
an index on the a column if it is an autonumber(identity )
column if I was using this column in joins or where clauses.
regards
Greg
- Original Message -
From: Michael Hunley
To: Greg Obleshchuk
Sent: Tuesday, February 10, 2004 6:49 AM
Subject: Re: [inbox] Re: [sqlite
5 matches
Mail list logo