Re: Why my query not using index to sort?

[Arup Rakshit <ar@xxxxxxx>]

Hi Adrian,

> The application is?

It is Ruby On Rails application

> The log settings are?

> Where is it being printed?

The default application log, the production.log file.

> What is being printed?

Check the gist: https://gist.github.com/aruprakshit/a6bd7ca221c9a13cd583e0827aa24ad6

Thanks,

Arup Rakshit

ar@xxxxxxx

On 29-Sep-2018, at 12:28 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:

On 9/28/18 11:51 AM, Arup Rakshit wrote:

Yes, I have shown the explain plan output. But in my application log the sql query prints 1.7 to 1.9 ms.

So you have added another layer to the process.

The application is?

The log settings are?

What is being printed?

Where is it being printed?

Thanks,
Arup Rakshit
ar@xxxxxxx <mailto:ar@xxxxxxx>

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx