Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

2004-02-10 Thread Bertrand Mansion
<[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

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

2004-02-09 Thread Greg Obleshchuk
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

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

2004-02-09 Thread D. Richard Hipp
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

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

2004-02-09 Thread Greg Obleshchuk
- 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

[sqlite] Re: [inbox] Re: [sqlite] Primary key and index

2004-02-09 Thread Greg Obleshchuk
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