Alan Harris-Reid wrote:
> I have a table with a primary key field called artist_id, which is also
> marked as autoincrement. If I want an index on this field
You don't. There is already an index on this field. SQLite automatically
generates an index to enforce PRIMARY KEY and UNIQUE constraints.
I have a table with a primary key field called artist_id, which is also
marked as autoincrement. If I want an index on this field (eg. to
improve performance when joining with other tables), do I have to index
it explicitly, or does the fact that it is already an autoincrement pk
field alread
hi,
i need some help to see if i understood the point about indexing.
if i have 2 tables. each table has 2 columns. and now i want to join those
tables through one column in each table:
example
T1
C1 C2
|
+--+
|
T2 |
C1 C2
let say the columns in question are C1(t1) and C2(t2)
first q
3 matches
Mail list logo
