2017-09-21 12:52 GMT+02:00 Subramaniam C :
> Hi
>
> I wanted to query top 20 rows by joining two tables, one table having
> around 1 lac rows and other table having 5 lac rows. Since I am using ORDER
> BY in the query so I created compound index with the columns being used in
> ORDER BY. Initially
Hi
I wanted to query top 20 rows by joining two tables, one table having
around 1 lac rows and other table having 5 lac rows. Since I am using ORDER
BY in the query so I created compound index with the columns being used in
ORDER BY. Initially index size was 939 MB.
Then I ran EXPLAIN(ANALYZE,BU
Hi Jeff,
Thanks for the update and clarification. I will look to see a better
alternative to resolve this twice execution of same plan.
On Wed, Sep 20, 2017 at 10:16 PM, Jeff Janes wrote:
> On Tue, Sep 19, 2017 at 7:31 PM, monika yadav
> wrote:
>
>> Hi All,
>>
>> I didn't understand why same s
