2 Replies Latest reply on Feb 17, 2009 4:09 PM by 630782

    SPARQL query with OPTIONAL


      When I run a SPARQL query with OPTIONAL in the WHERE clause, I saw a lot of "select 1 from ***" kind of queries got executed. The query runs very slow. I'm running Jena adaptor 2 against Oracle We have about half million triples in the model. The queries we need to run tend to be complex and they run pretty slow. Does Oracle have big query performance improvement over Is there anything that we can do on the application side or on the database side to boost the query performance? Thanks,