Would anyone by chance know why SQL Hints are not followed when executing a SQL statement via a LiveReport?
We have Oracle 11g and when I use SQL Developer to execute the SQL below, the execution plan recognizes the hint, but when I execute the same SQL via a LiveReport, the hint is not followed... Any thoughts?
select /*+ index_ffs(dtreecore, dtree_index1) */ K.ID AS "DATAID",K.Name AS "EID", K.LASTNAME AS "LASTNAME", K.FIRSTNAME AS "FIRSTNAME", K2.name AS "BASEGROUP", to_char(SUM((dv.datasize/(1024*1024))/1024), '999,999.999999') "Size in GB"
from kuaf k
join dtree dt on k.id = abs(dt.ownerid)
join dversdata dv on dt.dataid = dv.docid
join kuaf k2 on k.groupid = k2.id
where k.deleted = 0 and k.type = 0
Group by k.id, k.name, K.LASTNAME, K.FIRSTNAME, k2.name
I am attempting to get the Total Sizes of Personal Workspaces for each of our Active Users.
