Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Select from Cluster Table

Former Member

‎2008 May 18 1:45 PM

0 Likes
412

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

1 REPLY 1
Read only

vinod_vemuru2
Active Contributor

‎2008 May 18 2:21 PM

0 Likes
333

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.