Re: [sqlite] Indexes on the table

Thanks Simon for detail explaination about the indexes! JP From: Simon Slavin <slav...@hearsay.demon.co.uk> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, July 21, 2009 3:57:22 PM Subject: Re: [sqlite] Indexes

Re: [sqlite] Indexes on the table

On 21 Jul 2009, at 11:12pm, Joanne Pham wrote: > CREATE TABLE myTable( > startTime INTEGER ... > appId INTEGER > myId INTEGER ... > trafficType INTEGER > .. > ) > StartTime can be from 1...59 > appId can be from 1...256 > myId can be from 1...5000 > trafficType can be from

[sqlite] Indexes on the table

Hi All, I need to create the indexes on the tables and these indexes have 4 columns. Let say the table definition as below: CREATE TABLE myTable(     startTime INTEGER ...     appId INTEGER     myId INTEGER ...     trafficType INTEGER .. ) StartTime can be from 1...59 appId can be from