What would probably help is creating a metamorph index on URL with word expressions that match the /... and /.../ so that it can use the index for those LIKE statements. E.g.
set addexp='>>/=[^/]+';
set addexp='>>/=[^/]+/=';
create metamorph index html_Url on html(Url);
set addexp='>>/=[^/]+';
set addexp='>>/=[^/]+/=';
create metamorph index html_Url on html(Url);