Re: Best Query Rewrite?
> One rewrite I tried took only 3 minutes and 28 seconds
1. To measure the effects of query changes on performance, you need to disable query caching.
2. The tables have no keys. Not even primary keys, so they aren't even real tables! I'd start with indexes on imsi and timestamp_hour. You might have to add t1 Group By columns.
Subject
Written By
Posted
December 03, 2012 02:32PM
Re: Best Query Rewrite?
December 03, 2012 02:47PM
December 03, 2012 02:51PM
December 03, 2012 02:56PM
December 03, 2012 08:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.