topic Select from Cluster Table in Application Development and Automation Discussions

Select from Cluster Table

Former Member — Sun, 18 May 2008 12:45:49 GMT

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

Re: Select from Cluster Table

vinod_vemuru2 — Sun, 18 May 2008 13:21:23 GMT

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.