Select from Cluster Table

[Former Member]

Hi,

I want to read data fields name1 name2 name3 name4 from cluster table BSEC.

I tried select statement it takes lot of time.

Let me know if theres a better way.

Any help will be rewarded with points.

Thanks,

blluesh

[Former Member]

Hi,

Generally Select on cluster table will be very slow especially if u dont pass all the keys. Let me know what are all the fields u are passing to this select in WHERE clause. Also check the transperant table TCJ_CPD which has all name fields.

Thanks,

Vinod.

[vinod_vemuru2]

Hi,

Generally Select on cluster table will be very slow especially if u dont pass all the keys. Let me know what are all the fields u are passing to this select in WHERE clause. Also check the transperant table TCJ_CPD which has all name fields.

Thanks,

Vinod.