PropertyValue
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/ns/prov#value
  • It will indeed do a complete index scan.The technique works better the deeper into the composite index the missing column value is found.Even with a complete index scan, given that no better index exist, this may be more desireable than a table scan.As a note, if the scenario discussed was a reality, I would probably create two indexes.
http://www.w3.org/ns/prov#wasQuotedFrom
  • sqlservercentral.com