CREATE INDEX ON pxy_abstract_message(from_ip);
CREATE INDEX ON pxy_abstract_message(local_port);
CREATE INDEX ON pxy_abstract_message(proxy_port);
CREATE INDEX ON pxy_abstract_message(proxy_side);
CREATE INDEX ON pxy_abstract_message(remote_port);
CREATE INDEX ON pxy_abstract_message(result_oid);
CREATE INDEX ON pxy_abstract_message(to_ip);
CREATE INDEX ON pxy_abstract_message(appname);
CREATE INDEX ON pxy_abstract_message(facility);
CREATE INDEX ON pxy_abstract_message(hostname);
CREATE INDEX ON pxy_abstract_message(messageid);
CREATE INDEX ON pxy_abstract_message(severity);
CREATE INDEX ON pxy_abstract_message(timestamp);
CREATE INDEX ON pxy_abstract_message(date_received);
CREATE INDEX ON pxy_abstract_message(connection_id);
CREATE INDEX ON pxy_abstract_message(index);
CREATE INDEX ON pxy_abstract_message(index_int);
CREATE INDEX ON pxy_abstract_message(pxy_abstract_message_type);


CREATE INDEX ON  tm_configuration(host);
CREATE INDEX ON  tm_configuration(name);
CREATE INDEX ON  tm_configuration(port);
CREATE INDEX ON  tm_configuration(proxyport);
CREATE INDEX ON  tm_configuration(tmid);
CREATE INDEX ON  tm_configuration(type);
CREATE INDEX ON  tm_configuration(testinstance_id);

CREATE INDEX ON  tm_step(stepindex);
CREATE INDEX ON  tm_step(tmid);
CREATE INDEX ON  tm_step(testinstance_id);
CREATE INDEX ON  tm_step(message_id);