IDS Forum

Re: RES: functional index - create with parall....

Posted By: Cesar Inacio Martins
Date: Sunday, 5 September 2010, at 9:14 a.m.

In Response To: Re: RES: functional index - create with parallel s (Cesar Inacio Martins)

sorry.. just a correction.. ins't Growth Edition.. is Enterprise Edition..

--- Em sex, 3/9/10, Cesar Inacio Martins <cesar_inacio_martins@yahoo.com.br> escreveu:

De: Cesar Inacio Martins <cesar_inacio_martins@yahoo.com.br>
Assunto: Re: RES: functional index - create with parall.... [21173]
Para: ids@iiug.org
Data: Sexta-feira, 3 de Setembro de 2010, 21:51

Hi Celso,

In the last case what I get this situation is over a Growth Edition , with PDQ
and PSORT_NPROCS set..
But , when I says functional indexes, I means indexes based on functions,
something like:
create index xyz on tablexyz ( calc_day_payment(day_expires)).

And this over a non-fragmented table.. (maybe this is the cause of they run
serially), I don't remember if some day I run this over a fragmented table..

This kind of creation, don't run fews copies of the function in parallel with
PSORT_NPROCS, or with PDQ (=100 max_pdq = 100).
So, if I run this over a medium table , take too long because run serially and
the overhead of the function (SPL) just make the situation worst... running on
twice of the regular time.. in some cases...

Cesar

--- Em sex, 3/9/10, Celso Cabral Coimbra <ccoimbra@cleartech.com.br> escreveu:

De: Celso Cabral Coimbra <ccoimbra@cleartech.com.br>
Assunto: RES: functional index - create with parallel sort [21169]
Para: ids@iiug.org
Data: Sexta-feira, 3 de Setembro de 2010, 14:46

Cesar,

Are you using PDQ in which level? How are the Parallel Database Query (PDQ)
Configuration Parameters in your instance?
You should use PSORT_NPROCS and PDQ >1, actually.

In my environment to create indexes in parallel I usually use PDQ Priority
High, but the MAX_PDQPRIORITY is set to 25, if you would like to use all the
resources configured in PDQ, set MAX_PDQPRIORITY to 100 and use set
pdqpriority high (or 100).

If I really understood your problem, I think it can help you.

Celso Cabral Coimbra
Administrador de Banco de Dados
ClearTech Ltda
"Trust at the heart of Communications"
Tel. (11) 3576-4509

-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Cesar Inacio
Martins
Enviada em: quinta-feira, 2 de setembro de 2010 22:51
Para: ids@iiug.org
Assunto: functional index - create with parallel sort [21160]

Hi,

IDS 11.50 FC7

If a table have a functional Index, and the table don't have fragmentation,
but the PSORT_NPROCS is set with value > 1 (or PDQ >1), the index is created
by only one and single thread.
Why this creation don't run with more sort threads in parallel?
Once the functions are "NOT VARIANT" , I don't see why not...

There is some reason , what I don't see ?

Cesar

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• functional index - create with parallel sort
  Cesar Inacio Martins -- Thursday, 2 September 2010, at 9:50 p.m.
  • RES: functional index - create with parallel sort
    Celso Cabral Coimbra -- Friday, 3 September 2010, at 1:46 p.m.
    • Re: RES: functional index - create with parallel s
      Cesar Inacio Martins -- Friday, 3 September 2010, at 8:51 p.m.
      • Re: RES: functional index - create with parall....
        Cesar Inacio Martins -- Sunday, 5 September 2010, at 9:14 a.m.
        • Re: RES: functional index - create with parall....
          rroussey@comcast.net -- Monday, 6 September 2010, at 10:29 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.