Normal query on cluster/pooled tables...

[Former Member]

Hi experts,

Can i write a normal sql query on cluster or pooled tables?

Will it create any sort of problem?

Regards,

Viswanathan .S

[naveenvishal]

Hi Viswanathan,

It is not recommended to access them directly due to there size like tables BSEG, CDPOS.

Report may run smooth on dev but will slow down as data increases in case of production server.

There are alternative tables available for their substitution. Which table(s) are you trying to access anyways ?

Regards,

Naveen

[Former Member]

Thanks Naveen, I asked it in general terms. Anyways, I was trying to access konv.

[Former Member]

It will not create any problem you have to just look after the key fields if you do not have full key fields.

select on these tables will give very poor performance because it contain a lot of data.