Database, XML

How to create XMLIndex? When its worth to use it?

How to create XML index? Very general way with all default applied as follows: create index index_name on table_name (xmltype_column) indextype is xdb.xmlindex; Check the name of PATH table select path_table_name from user_xml_indexes  where table_name = ‘table_name’ and index_name = ‘index_name’;  Check what secondary indexes are used select c.index_name, c.column_name, c.column_position, e.column_expression  from user_ind_columns c left outer join user_ind_expressions e…

Continue Reading