Ah! I use these all the time with PhotoStructure--it's great for "work-in-progress" rows that shouldn't be shown to the user quite yet (but I need the row added

Ah! I use these all the time with PhotoStructure--it's great for "work-in-progress" rows that shouldn't be shown to the user quite yet (but I need the row added as I need to populate join tables with the primary key), or rows that are no longer relevant (due to files disappearing or becoming unreadable), but might return, so I'm not wanting to delete it quite yet. The syntax looks like: CREATE INDEX ON Asset (capturedAt) WHERE visible = 1; And (like with any index and any RDBMS), you have to remember to include that column in any relevant WHERE clause for the index to be considered relevant.