Re: Help with VIEWS

From: "John Alden" >>
Here is my dilemma:
Platform: WindowsNT4 - Oracle8 I have two seperate databases on two seperate machines with identical schemas , tables, etc... When querying one table with the view it is fast.... the other slowwwwwwww Is there something in the settings or that i might be missing
any suggestion would be welcome..... Thanks in advance - Confused in Millburn,NJ
<<

Are both queries local or one is one distributed?

Are you using the cost based optimizer?

Are the quantities of data the same?

Without more information the best guess I can make is to analyze the view's base tables and try the query locally on both machines again. If the performance varies and the quanity of data does not then take a look at the tablespace to disk layout. Also verify that the number and composition of indexes on the base tables match even though you did say identicial looking schemas.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sun Apr 25 1999 - 13:26:02 CDT