Current position:  Home > Default > Performance Of  Views

Performance Of  Views

Time:November 30
Advertisement
Hi Guys,
I have a view which is made for four different Views ,
Now The Problem is Its Taking lot of time to Run as the sub Views are having Lot of conditions and joins.
What are the Options I have except making Mview of the same to increase performance of the Main View .
-Manish
Advertisement
Hi Manish,
1) you don't "use nested joins" in a query. you do joins, and then let the optimizer decide whether they are going to be implemented as nested loops, hash joins or merge joins
2) NL don't cost anything -- i.e. their cost is simply the cost of acquiring the two row sources. You don't reduce the cost of a nested loop -- you reduce the cost of the access paths for NL row sources, and you make sure that NL is appropriate join method in this situation
3) better yet -- just make sure that stats are accurate, and the optimizer will choose the optimal plan for you. If this doesn't work, post a tuning request in a separate thread (read FAQ carefully before doing that)
Best regards,
Nikolay

Cannot perform cube view operation, null

-0001-11-30

Hi There, Users use SmartView connect to the 11.1.1.3 cube, but get the following error: "Cannot perform cube view operation, null" Any advice? ThanksIt is a stupid meanless message for the real issues. The users have suppress missing turned on

[sql performance] inline view , group by , max, join

2015-10-11

Hi. everyone. I have a question with regard to "group by" inline view , max value, join, and sql performance. I will give you simple table definitions in order for you to understand my intention. Table A (parent) C1 C2 C3 Table B (child) C1 C2 C

Performance of view wwsbr_all_folders very bad when user is public

-0001-11-30

I have some routines that build navigation components based upon selects from the view wwsbr_all_folders They work great after a user is logged in, but if the user is public, the performance is extremely slow. It is so slow that the page often times

Performance on views

-0001-11-30

Hello All, We noticed performance issue when tryi ng to select data from a view. Below is the detail on this view: 1. View Definition: CREATE OR REPLACE FORCE VIEW baninst1.sgvacur (sgvacur_pidm,                                                sgvacur

Performance ora:view and collection()

-0001-11-30

ora:view allows an XML structured table to be used in a XQuery "for" clause, while collection processes a set of documents in a directory. Normally these are two different sets of data. However, with XDB I can have a WEBDAV directory which can c

Performance regarding view

-0001-11-30

hi, i have a view named CREATE OR REPLACE VIEW TAX_AMT_VIEW (PTIN_NO, AMOUNT) AS select I_ASMTNO PTIN_NO, (D_CRNPT+D_CRNED+D_CRNLCS+D_CRNUAUTHCNSTPLTY+D_ARRPT+D_ARRED+D_ARRLCS D_ARRUAUTHCNSTPLTYD_PLTYONARR+D_ADVAMT) AMOUNT from DMA12.PT_ASMTRCPT_TBL;

Performance of View

-0001-11-30

Hi, I have created a complex view A with user defined function as column. Then created another view B by selecting from the previous view. Now when I query the view B the perfornance well but when I use order by clause in the query then the performan

JSF 2.0 Performance - Build View on postback

2015-10-11

Hi, we are currently looking at JSF 2.0 and it seems as if on every postback a buildView is executed instead of a restoreView, as it was the case with JSF 1.2. This unfortunately seems to have quite an impact on performance in regards to memory consu

Bad performance: Xpath View causes database server almost 100% cpu

-0001-11-30

Hi there, Since I am rather inexperienced in using the Oracle XML DB I wonder If I am doing wrong with the following: I created a table with a xmltype column in it: CREATE TABLE LPD_LOAD_XML FILENAME VARCHAR2(50 BYTE) NOT NULL, XML_CONTENT SYS.XMLTYP

Performance issue: View query is calculating a column value before filterin

-0001-11-30

Hi, I have a view like this.(My view is more complex than this..I just tried to imitate the situation ) Select emp_id, emp_name, calculate_salary(emp_id) salary   From employees Where nvl(department, '@@##$$') = nvl(get_global.department, '@@##$$')Wh

MD5 and RSA - Slow performance  - Help / Views Required

-0001-11-30

Hi, I am facing a problem while signing a message.The scenario is: I have to create 20,000 messages to be sent to clients. I am encrypting the message using MD5 and RSA. But when i am encrypting via RSA it takes about 20 mins to encrypt the 20k messa

Implementing the performance reporter & viewer tools in EP 6.0 SP11

-0001-11-30

Hi Friends I'm trying to implement OSS note 766598 for better analysis of the java monitoring data for EP 6.0 on WAS 6.40, the note mentions about downloading & deploying the j2ee application attached in the note, though it doesn't specifies which is

Smart View Error

2015-10-11

I'm struggling to change grid retrieves, which is a new post Fusion problem. If I copy and paste a different account line onto the grid I get this message that reads - "Excel sheet has modified data cells. Do you want to submit the modified data cell

How to speed up the performance in Oracle APEX - Classical Report loading

2015-10-11

Hi, I am using APEX 4.2, DB 11.2. I have created 2 reports in the page and the time that is taken to load this page is very huge. To speed up the performance materialized views were used on queries, but still the performance is the same. checked the

Something weird happening with View Options....

2015-10-11

Hi!, OK, so I go into my hard drive root (where the library, users, system folders are). I go to the View menu and choose Show View Options. In that small panel, I check the Show Item info checkbox so that it shows me all the info about folders. I en

ODI Error: While running interface to perform Essbase ouline extraction

2015-10-11

Hi All, I have requiremnet to extract all dimensions from Essbase outline and put them into Flat Files. I created Essbase and Flatfile model and reversed successfully. I created interfaces for each dimension for extracting its metadata to flat file.

Drill-Through Error Smart View And Web Analysis

2015-10-11

Hi, After upgrading to Hyperion 11.1.2.1 , I get below error for drill through define from EIS. I get error when performing drill through from Smarview and Web ANalysis. Error :- [1033] Native: 4006 Error: Internal Essbase JAPI error: [Cannot perform

Is it OK to join to a view twice in the same select?

2015-10-11

For instance In this case RPT_PRIMARY_PATRON_DETAIL is a view. SELECT PATRON_ORDER.FINANCIAL_PATRON_ACCOUNT_ID, FIN_PATRON_DETAIL.PATRON_ACCOUNT_NAME, PATRON_ORDER.ATTENDING_PATRON_ACCOUNT_ID, SO_PATRON_DETAIL.PATRON_ACCOUNT_NAME FROM RPT_COMMON_ORDE

Viewer slow while retrieving data while changing value from a page item

-0001-11-30

Hi, I am using 9.0.2 to create reports. My end-users are using Viewer to run these reports. Recently, we are experiencing performance problems with Viewer. We have reports with Page Item. Let say a report takes 1 min to run. After running the report