SQLite Forum

index to help with selection and ordering
Fair point.

Thinking through my scenario a bit more I conclude that the temp b=tree for ordor by is far less of an issue compared to the table scan.  In other words, if the index is used to retrieve a reasonable number of rows (using table search) then the sorting is a pretty much a non-issue.  If the select is returning a large number of rows then the order by is a problem but the whole query is problematic.

Thanks again.