Thanks Simon for detail explaination about the indexes!
JP
From: Simon Slavin
To: General Discussion of SQLite Database
Sent: Tuesday, July 21, 2009 3:57:22 PM
Subject: Re: [sqlite] Indexes on the table
On 21 Jul 2009, at 11:12pm, Joanne Pham wrote
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 1..
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 1...256
3 matches
Mail list logo