Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    1

    Angry Unanswered: Issues using views in ids 7.3

    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

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    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.
    Fred Prose

  3. #3
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    update statistics and create index for join column
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •