CREATE VIEW cd_master (Title, Artist, Website, Description) AS
SELECT extractValue(value(x),'/CD/Title'),
      extractValue(value(x),'/CD/Artist'),
      extractValue(value(x),'/CD/Website'),
      extractValue(value(x),'/CD/Description')

FROM CD331_TAB x;

CREATE INDEX by_artist ON CD331_TAB x (
   extractValue(value(x),'/CD/Artist'));

ANALYZE TABLE cd331_tab COMPUTE STATISTICS FOR TABLE;


ANALYZE INDEX by_artist COMPUTE STATISTICS;