database view

[Former Member]

Hi Friends,

when i am executing the database view(contents)..

its taking so much time.

what is the reason..and i am giving max no.of hits are only 10.

why its taking so much time.

pls. anyone explain.

regards,

[Former Member]

Database views are implemented with an equivalent view on the database.

Database views should be created if want to select logically connected data from different tables simultaneously.

Database views implement an inner join.

Application programs can access the data of a database view using the database interface. (Just as we write select queries on database tables, we can write them for views as well.)

So when you execute view, it executes the definition.This definition execution is taking a long time. Which db view are you executing?

ashish

[Former Member]

Hi Ashish,

it is a zview .. not standard view...

the zview is created bt 3 tables ..

that are cobk , coep and CE4HINC_ACCT tables..

i am executing this vew directly.. its exection time very slow.

help me.. what is the reason.

regards,

[Former Member]

Would you post the code of the SELECT statement from your program?

Rob

[Former Member]

hi rob,

i am not executing the view from report.

i am exceting view directly..

it is taking so much time..

in this view .. there are 3 tables are used.(joined)

regards,

[Former Member]

Then what are the join conditions for the view?

Rob

[Former Member]

COPA tables contain huge data. you need to be very specific while joining the tables.

Please check JOIN conditions. And try to be as specific as you can by adding more conditions.

ashish

[Former Member]

Hi Venu,

Check whether you have JOIN condition on primary key of tables. Sometimes it will take lot of time if you have JOIN condition on non-primary key values.

Thanks,

Vinay

[Former Member]

Would you post the code please?

Rob