This content has been marked as final. Show 2 replies
create index idx1 on family_rdf_data(triple.get_property());
There should not be a need to use to_char() in your query I think. to_char() can be necessary if the index is on triple.get_object() if some object values are greater than 4000 characters (and hence stored as CLOBs).
We are running a Oracle10g (Release 10.2.0.3.0). What is the syntax for forcing Oracle to use an index in SPARQL queries (we use the Jena plugin for full SPARQL support).
Thanks for your help!