Re: [sqlite] composite PK Constraint: effects on query performance?

Tim Romano wrote: > Does SQLite 3.1.x tacitly create an index to implement composite PK > constraints, and is that index used, when possible, to enhance the > performance of joins and order by clauses? Yes and yes. Igor Tandetnik ___ sqlite-users

[sqlite] composite PK Constraint: effects on query performance?

Does SQLite 3.1.x tacitly create an index to implement composite PK constraints, and is that index used, when possible, to enhance the performance of joins and order by clauses? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org