On 24 May 2016 at 12:18, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:On Mon, May 23, 2016 at 4:23 PM, Lucas Possamai <drum.lucas@xxxxxxxxx> wrote:
>
> That index has been added just 3 hours ago, and you can see that the
> times_used goes over 41000.... How is that possible??
Well, that is what it is there for, right , to be used? My ancient
laptop can use an index that many times in less than 20 seconds,
running flat out.
Yeah!
But I mean... over 70.000 times in 4 hours? that's a lot of usage! ahhahaha>
> Don't think the query is right.
>
> Can you please check ?
The query seems right to me.
Cheers,
JeffI think the query is ok.. just wanna understand if that value is correct :OIf it is.. I'm happy with that. Just shows the work of finding and creating the index worthed it.
I don't have the answer off hand but what is it counting? If it counts, say, each lookup into the index during a nested loop evaluation the difference in perception could be easily explained.
David J.
