Hi Albe,
We have checked as per your suggestion and we are good now.
Thank you !!!
On Thu, 11 Feb, 2021, 8:49 PM Brajendra Pratap, <
brajendra.pratap...@gmail.com> wrote:
> Hi Albe,
>
> Thank you so much for information, will check this and get back to you if
> any help required.
>
> I have a
Hi Albe,
Thank you so much for information, will check this and get back to you if
any help required.
I have a doubt why didn't the parallelism works here ,could u plz guide me?
Thank you so much again.
On Thu, 11 Feb, 2021, 1:23 PM Laurenz Albe,
wrote:
> On Thu, 2021-02-11 at 05:09 +0530, Br
On Thu, 2021-02-11 at 05:09 +0530, Brajendra Pratap wrote:
> I am unable to execute the below in parallel plz suggest how can I achieve
> parallelism here.
>
> select count(*) over () VIEWALLROWCOUNT,abc.*,ROW_NUMBER() OVER (order by
> trn_transaction_date desc ) AS RowNumber from (
> select *
Hi,
I am unable to execute the below in parallel plz suggest how can I achieve
parallelism here.
select count(*) over () VIEWALLROWCOUNT,abc.*,ROW_NUMBER() OVER (order by
trn_transaction_date desc ) AS RowNumber from (
select * from transactions where trn_store_date_id=20201202) abc;
Query plan
