On 4/15/2013 2:12 PM, ven...@intouchmi.com wrote:
That's odd, I had listed the tables and keys in the original message.
Here is that section again:
which generates about 16000 rows.
The row counts and primary keys for the referenced tables are:
Objects = 5495, Object_ID;
DTC_Statuses = 5234, DTC_Status_ID;
Object_TextTables = 15718,
Object_Transactions = 5747, Object_Transaction_ID;
Equations = 43, Equation_ID;
Equation_Types = 10, Equation_Type_ID;
Object_Types = 5, Object_Type_ID;
DisplayFormats = 7, DisplayFormat_ID.
I assumed that primary keys are indexes.
Yes, primary keys are backed by indexes. But I'm asking about indexes on
fields other than primary key - e.g. DTC_Statuses(Object_ID), not
DTC_Statuses(DTC_Status_ID). What good is an index on DTC_Status_ID when
no joins mention it?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
