Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    40

    Unanswered: Left Outer Join View Slow

    Can someone help me with this view? I have added indexes, partitioned large tables by date and partitioned indexes. This view still takes 10 minutes to populate:
    Attached Files Attached Files
    Last edited by israel05; 05-12-06 at 16:34.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >This view still takes 10 minutes to populate:
    What does the EXPLAIN PLAN show?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    1) you REALLY should follow the #1 STICKY NOTE & use code tags to make this mess more readable.

    CREATE OR REPLACE VIEW IT.GIS_ACC
    (A,R,M,X,Y,C,A,FS,V,I,LT,FT,S,C,CV,P)

    Why are there two "A" & two "C" in this list above?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Aug 2005
    Posts
    40
    nnnnnnnnnn
    Last edited by israel05; 05-14-06 at 23:34.

Posting Permissions

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