Hi Would it do any good to restrict the transaction date for the limit to something like "current timestamp - 1 day/hour/month". How about partitioning?
My two dimes Thiemo
- Re: Top -N Query performance issue and high CPU usage David Mullineux
- Re: Top -N Query performance issue and high CPU usage Adrian Klaver
- Re: Top -N Query performance issue and high CPU usage yudhi s
- Re: Top -N Query performance issue and high CPU u... Ron Johnson
- Re: Top -N Query performance issue and high C... Luigi Nardi
- Re: Top -N Query performance issue and high CPU u... Peter J. Holzer
- Re: Top -N Query performance issue and high C... Ron Johnson
- Re: Top -N Query performance issue and high C... yudhi s
- Re: Top -N Query performance issue and hi... yudhi s
- Re: Top -N Query performance issue a... Thiemo Kellner
- Re: Top -N Query performance issue and high C... yudhi s
- Re: Top -N Query performance issue and hi... Ron Johnson
- Re: Top -N Query performance issue a... yudhi s
- Re: Top -N Query performance iss... Ron Johnson
- Re: Top -N Query performance iss... yudhi s
- Re: Top -N Query performance iss... Ron Johnson
- Re: Top -N Query performance iss... yudhi s
- Re: Top -N Query performance iss... Ron Johnson
- Re: Top -N Query performance iss... yudhi s
- Re: Top -N Query performance iss... Ron Johnson
