Hey guys.

I have the following table:

infPlayTable (id INTEGER PRIMARY KEY AUTOINCREMENT, infId INTEGER, name 
TEXT NOT NULL UNIQUE, score REAL)

I often need to do the following:

SELECT name, score FROM infPlayTable WHERE infId = 670 ORDER BY score DESC

What is the syntax for the index I need to create on InfPlayTable to 
have that be quick?

Thanks,
Ian
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to