Problem with view in large SQL 
Author Message
 Problem with view in large SQL

I decided to fix a design flaw in a system I'm working on to split a
database table into 2. I created a view which joined them back together in a
way that was indistinguishable from the original.

Most of the system worked unchanged, however a few of the most horrendously
complex SQLs with some old fashioned syntax

(LEFT INNER JOIN (SYMBOLS INNER JOIN

etc... involving 9 or more tables produced bad results when the table was
replaced with the view.

Is there any "known problem" I should be aware of concerning this? Has
anyone experienced this & found an easy fix?

I really don't want to attempt to rewrite those SQLs because of the testing
load that would add to the project. So the alternative is to go back to the
old inefficient table structure. I would really appreciate any suggestions
which would allow me to avoid doing that.

Thanks.

NEIL



Fri, 07 Mar 2003 03:00:00 GMT
 Problem with view in large SQL

Hi,

Can you post the old table structure, the new one and one of the queries
that misbehaves (with enough DDL to get it parsed)?
The Version of DB2 is helpfull, too :-)

Would be interesting to see where it goes of...
One reason that comes to mind is that DB2 could now be sharing thw view
rather than redoing the join everytime. This could lead to system temp
tables and failure to push down some predicates.

Cheers
Serge

--
Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.ibm.com/software/data/db2/udb/winos2unix/support



Sat, 08 Mar 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problem with a large view (SQL error -264 / ISAM -131)

2. A problem with large views

3. A problem with large views

4. Problem with a large view (worked on 7.30 but not on 7.31)

5. Large Query Causes Large Problem

6. SQL 7.0 views vs SQL 2000 views

7. Reference needed - Current Large (Largest) SQL 7.0 Database?

8. Can't view Very Large Dimensoin

9. Large VIEWS

10. VIEWs within VIEWs and Primary Key problem

11. SELECT from a View of 2 views - problem

12. large number of views in 6.5


 
Powered by phpBB® Forum Software