sqlite - Non-Unique Index on sqllite database table in phonegap -

sqlite - Non-Unique Index on sqllite database table in phonegap -

i using phonegap default database. reading documentation, not mention indexes on database tables (aka primary key, unique index, or index). http://docs.phonegap.com/en/1.2.0/phonegap_storage_storage.md.html

but when @ illustration code: http://www.raymondcamden.com/index.cfm/2011/10/20/example-of-phonegaps-database-support

i can see ray uses "primary key".

my 3 questions are:

is there definitive guide sql syntax supported in phonegap? are non-primary key indexes supported in phonegap? assuming #2, appropriately placed indexes speed code (or keywords read , ignored)?

for practical purposes, phonegap implementations utilize sqlite, can utilize everything supported sqlite.

sqlite cordova