Find below tow queries.
select count(*), sum(H.HIST_VALUE) from HISTORIC_DATA H, CURRENT_DATA C, GENERIC_NAME G where H.HIST_TIMESTAMP >= '03/17/04' and H.DATAID=C.DATAID and C.PLANTID=853 and H.HIST_QUALITY = 192 and C.GENERIC_NAMEID = 1156 and H.GENERIC_NAMEID=G.GENERIC_NAMEID and C.PRODUCT_CODE = 'LIN'
select count(*), sum(CURR_VALUE) from CURRENT_DATA where GENERIC_NAMEID =1126 and PRODUCT_CODE = 'Generic' and PLANTID = 534
Tables HISTORIC_DATA and CURRENT_DATA do not contain any primary keys / indexing (can not be created due to other dependancies). All other fields in other tables (referred in the query) are primary keys.
Right now these two queries execute at 0.0118 sec approximately. I am not sure whether this time is good or bad. Is there a scope for performance improvements in these two queries?