Question : This Query scans only one document and returns only one document. But this is very slow: 2017-05-22T07:13:24.548+0000 I […]

Question : Consider the following query: SELECT table_name, to_number(extractvalue(xmltype(dbms_xmlgen.getxml(‘select count(*) c from ‘ ||owner ||’.’ ||table_name)),’/ROWSET/ROW/C’)) AS COUNT FROM all_tables […]