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
myId can be from 1...5000
trafficType can be from 1..3
I would like to create index for this table on these columns StartTime ,appId,
myId, trafficType as :
create unique index myTableIndex on myTable(appId, myId, trafficType,
startTime).
Is the order of the columns in the create index statement importance? If yes
then what is rule of thumb here?
Thanks
JP
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
