Issues using views in ids 7.3

Dublinboy · #1 (**permalink**) 05-13-04, 06:56

Hi all,
I am trying to use view in ids v7.3. but i am having performance issues with it. It seems like its creating the view on the fly. I have mulitple joins to be perfomed and so i created the view.
Has anybody got any suggestion.

Cheers
Sharad

fprose · #2 (**permalink**) 05-14-04, 14:42

A view by itself typically gives no degredation. Look at the output of SQLEXPLAIN to see what the optimizer is attempting to do. You could compare that to the sql/joins without the view. They should be the same.

jh1213 · #3 (**permalink**) 05-17-04, 06:50

update statistics and create index for join column

Internet Services

Web Development

Digital Marketing

Consumer Tech