....When writing SPARQL queries, should I be aware of any particular index? Should I create new indexes myself (how)?
You 'can' create text-indexes for selected properties of your data for text search with a much better performance:
https://jena.apache.org/documentation/query/text-query.html -- Using Opera's mail client: http://www.opera.com/mail/
