Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view creation with subquery
Materialized view creation with subquery [message #190723] Fri, 01 September 2006 00:13 Go to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi,
I have a query :

SELECT E.FULL_NAME, E.EMPLOYEE_NUMBER, E.EMPLOYEE_TYPE, E.SUPERVISOR_NAME, E.OBU_NAME, E.CENTER_NAME, 
    E.PROGRAM_NAME, E.LOCATION, E.MODE_OF_DELIVERY, E.ROLE, E.BAND, E.ATTRIBUTE7, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE= 
    CASE TO_CHAR(SYSDATE, 'D') 
  WHEN '1' THEN TRUNC(SYSDATE)-13 
  WHEN '2' THEN TRUNC(SYSDATE)-7 
  WHEN '3' THEN TRUNC(SYSDATE)-8 
  WHEN '4' THEN TRUNC(SYSDATE)-9 
  WHEN '5' THEN TRUNC(SYSDATE)-10 
  WHEN '6' THEN TRUNC(SYSDATE)-11 
  WHEN '7' THEN TRUNC(SYSDATE)-12 
  END 
) AS PREV_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-34 
WHEN '2' THEN TRUNC(SYSDATE)-28 
WHEN '3' THEN TRUNC(SYSDATE)-29 
WHEN '4' THEN TRUNC(SYSDATE)-30 
WHEN '5' THEN TRUNC(SYSDATE)-31 
WHEN '6' THEN TRUNC(SYSDATE)-32 
WHEN '7' THEN TRUNC(SYSDATE)-33 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_3WEEK_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-97 
WHEN '2' THEN TRUNC(SYSDATE)-91 
WHEN '3' THEN TRUNC(SYSDATE)-92 
WHEN '4' THEN TRUNC(SYSDATE)-93 
WHEN '5' THEN TRUNC(SYSDATE)-94 
WHEN '6' THEN TRUNC(SYSDATE)-95 
WHEN '7' THEN TRUNC(SYSDATE)-96 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_13WEEK_YIELD 
FROM 
DEV_BLUE_BOOK E;



I tried to create a materialized view for this:

CREATE MATERIALIZED VIEW DEV_BLUE_BOOK_YIELD_REP_MV
TABLESPACE DEVELOPMENT
NOCACHE
LOGGING
NOPARALLEL
REFRESH FORCE
START WITH sysdate
NEXT SYSDATE + 12/24  
AS 
SELECT E.FULL_NAME, E.EMPLOYEE_NUMBER, E.EMPLOYEE_TYPE, E.SUPERVISOR_NAME, E.OBU_NAME, E.CENTER_NAME, 
    E.PROGRAM_NAME, E.LOCATION, E.MODE_OF_DELIVERY, E.ROLE, E.BAND, E.ATTRIBUTE7, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE= 
    CASE TO_CHAR(SYSDATE, 'D') 
  WHEN '1' THEN TRUNC(SYSDATE)-13 
  WHEN '2' THEN TRUNC(SYSDATE)-7 
  WHEN '3' THEN TRUNC(SYSDATE)-8 
  WHEN '4' THEN TRUNC(SYSDATE)-9 
  WHEN '5' THEN TRUNC(SYSDATE)-10 
  WHEN '6' THEN TRUNC(SYSDATE)-11 
  WHEN '7' THEN TRUNC(SYSDATE)-12 
  END 
) AS PREV_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-34 
WHEN '2' THEN TRUNC(SYSDATE)-28 
WHEN '3' THEN TRUNC(SYSDATE)-29 
WHEN '4' THEN TRUNC(SYSDATE)-30 
WHEN '5' THEN TRUNC(SYSDATE)-31 
WHEN '6' THEN TRUNC(SYSDATE)-32 
WHEN '7' THEN TRUNC(SYSDATE)-33 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_3WEEK_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-97 
WHEN '2' THEN TRUNC(SYSDATE)-91 
WHEN '3' THEN TRUNC(SYSDATE)-92 
WHEN '4' THEN TRUNC(SYSDATE)-93 
WHEN '5' THEN TRUNC(SYSDATE)-94 
WHEN '6' THEN TRUNC(SYSDATE)-95 
WHEN '7' THEN TRUNC(SYSDATE)-96 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_13WEEK_YIELD 
FROM 
DEV_BLUE_BOOK E;


When I try to execute this, it gives me an error:
ORA-22818: subquery expressions not allowed here



I used a workaround to deal with this, I created a view for this big query and used that view to create the materialized view.

CREATE OR REPLACE VIEW DEV_BLUE_BOOK_YIELD_REP_V
AS 
SELECT E.FULL_NAME, E.EMPLOYEE_NUMBER, E.EMPLOYEE_TYPE, E.SUPERVISOR_NAME, E.OBU_NAME, E.CENTER_NAME, 
    E.PROGRAM_NAME, E.LOCATION, E.MODE_OF_DELIVERY, E.ROLE, E.BAND, E.ATTRIBUTE7, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE= 
    CASE TO_CHAR(SYSDATE, 'D') 
  WHEN '1' THEN TRUNC(SYSDATE)-13 
  WHEN '2' THEN TRUNC(SYSDATE)-7 
  WHEN '3' THEN TRUNC(SYSDATE)-8 
  WHEN '4' THEN TRUNC(SYSDATE)-9 
  WHEN '5' THEN TRUNC(SYSDATE)-10 
  WHEN '6' THEN TRUNC(SYSDATE)-11 
  WHEN '7' THEN TRUNC(SYSDATE)-12 
  END 
) AS PREV_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-34 
WHEN '2' THEN TRUNC(SYSDATE)-28 
WHEN '3' THEN TRUNC(SYSDATE)-29 
WHEN '4' THEN TRUNC(SYSDATE)-30 
WHEN '5' THEN TRUNC(SYSDATE)-31 
WHEN '6' THEN TRUNC(SYSDATE)-32 
WHEN '7' THEN TRUNC(SYSDATE)-33 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_3WEEK_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-97 
WHEN '2' THEN TRUNC(SYSDATE)-91 
WHEN '3' THEN TRUNC(SYSDATE)-92 
WHEN '4' THEN TRUNC(SYSDATE)-93 
WHEN '5' THEN TRUNC(SYSDATE)-94 
WHEN '6' THEN TRUNC(SYSDATE)-95 
WHEN '7' THEN TRUNC(SYSDATE)-96 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_13WEEK_YIELD 
FROM 
DEV_BLUE_BOOK E;

--view created

--create materialized view using that view
CREATE MATERIALIZED VIEW DEV_BLUE_BOOK_YIELD_REP_MV 
TABLESPACE DEVELOPMENT
NOCACHE
LOGGING
NOPARALLEL
REFRESH FORCE
START WITH SYSDATE
NEXT SYSDATE + 12/24  
AS 
SELECT * FROM DEV_BLUE_BOOK_YIELD_REP_V;



1)I wanted to know whether there is any other workaround for this.
2)Is there any disadvantage in my approach

Re: Materialized view creation with subquery [message #190892 is a reply to message #190723] Fri, 01 September 2006 22:29 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Yeah, that's an interesting one. Sub-query expressions are a bit unusual - they seem to get executed only at FETCH time as the rows are returned. Perhaps there's some reason why this is incompatible with an MV; embedding it in a view would mean that the sub-query extressions were executed along with the outer query.

I don't see any problem with the view. You could possibly avoid it by wrapping the SQL query in an inline view though:

SELECT *
FROM (
... your query ...
)

If that doesn't work, try adding "ROWNUM AS rn" to the end of your query - that should stop Oracle trying to merge the inline view.

You could also try rewriting the query so that it doesn't use sub-query expressions.

Ross Leishman
Re: Materialized view creation with subquery [message #191039 is a reply to message #190892] Mon, 04 September 2006 04:39 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi,
I could not understand the below part of your post. Can you elaborate?

If that doesn't work, try adding "ROWNUM AS rn" to the end of your query - that should stop Oracle trying to merge the inline view.


Regards,
Anand
Re: Materialized view creation with subquery [message #191132 is a reply to message #191039] Tue, 05 September 2006 00:01 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
CREATE MATERIALIZED VIEW DEV_BLUE_BOOK_YIELD_REP_MV
TABLESPACE DEVELOPMENT
NOCACHE
LOGGING
NOPARALLEL
REFRESH FORCE
START WITH sysdate
NEXT SYSDATE + 12/24  
AS 
SELECT *
FROM (
  SELECT E.FULL_NAME
  , E.EMPLOYEE_NUMBER
  ...
  , ROWNUM AS RN 
  FROM ...
)


The ROWNUM should stop Oracle from internally merging your SELECT with the outer SELECT *. This means that the sub-query expressions will be "hidden" from the MV columns.
This may not even be necessary, just try it if it doesn't work with the SELECT * wrapper. Or, stick with you current work-around.

Ross Leishman
Re: Materialized view creation with subquery [message #191151 is a reply to message #191132] Tue, 05 September 2006 01:15 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi,
I tried your approach, it gives the same error.

Below is my trial:

CREATE MATERIALIZED VIEW DEV_TEST_MV 
TABLESPACE DEVELOPMENT
NOCACHE
LOGGING
NOPARALLEL
REFRESH FORCE
START WITH TO_DATE('05-Sep-2006 12:32:14','dd-mon-yyyy hh24:mi:ss')
NEXT SYSDATE + 12/24  
AS 
SELECT * FROM (
SELECT E.FULL_NAME, E.EMPLOYEE_NUMBER, E.EMPLOYEE_TYPE, E.SUPERVISOR_NAME, E.OBU_NAME, E.CENTER_NAME, 
    E.PROGRAM_NAME, E.LOCATION, E.MODE_OF_DELIVERY, E.ROLE, E.BAND, E.ATTRIBUTE7, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE= 
    CASE TO_CHAR(SYSDATE, 'D') 
  WHEN '1' THEN TRUNC(SYSDATE)-13 
  WHEN '2' THEN TRUNC(SYSDATE)-7 
  WHEN '3' THEN TRUNC(SYSDATE)-8 
  WHEN '4' THEN TRUNC(SYSDATE)-9 
  WHEN '5' THEN TRUNC(SYSDATE)-10 
  WHEN '6' THEN TRUNC(SYSDATE)-11 
  WHEN '7' THEN TRUNC(SYSDATE)-12 
  END 
) AS PREV_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-34 
WHEN '2' THEN TRUNC(SYSDATE)-28 
WHEN '3' THEN TRUNC(SYSDATE)-29 
WHEN '4' THEN TRUNC(SYSDATE)-30 
WHEN '5' THEN TRUNC(SYSDATE)-31 
WHEN '6' THEN TRUNC(SYSDATE)-32 
WHEN '7' THEN TRUNC(SYSDATE)-33 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_3WEEK_YIELD, 
 (SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE BETWEEN 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-97 
WHEN '2' THEN TRUNC(SYSDATE)-91 
WHEN '3' THEN TRUNC(SYSDATE)-92 
WHEN '4' THEN TRUNC(SYSDATE)-93 
WHEN '5' THEN TRUNC(SYSDATE)-94 
WHEN '6' THEN TRUNC(SYSDATE)-95 
WHEN '7' THEN TRUNC(SYSDATE)-96 
END 
AND 
CASE TO_CHAR(SYSDATE, 'D') 
WHEN '1' THEN TRUNC(SYSDATE)-13 
WHEN '2' THEN TRUNC(SYSDATE)-7 
WHEN '3' THEN TRUNC(SYSDATE)-8 
WHEN '4' THEN TRUNC(SYSDATE)-9 
WHEN '5' THEN TRUNC(SYSDATE)-10 
WHEN '6' THEN TRUNC(SYSDATE)-11 
WHEN '7' THEN TRUNC(SYSDATE)-12 
END 
) AS PREV_13WEEK_YIELD, ROWNUM AS RN
FROM 
DEV_BLUE_BOOK E);



It gives me the same error. So I think I have no option but to use my old approach.

Any other suggestions are welcome.

Regards,
Anand
Re: Materialized view creation with subquery [message #307704 is a reply to message #190723] Wed, 19 March 2008 10:36 Go to previous messageGo to next message
drealecs
Messages: 2
Registered: March 2008
Junior Member
a second choice for you is to use a function to return the result from that select.
so instead of
(SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
FROM APPS.YIELD_CALC 
WHERE E.PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE= 
    CASE TO_CHAR(SYSDATE, 'D') 
  WHEN '1' THEN TRUNC(SYSDATE)-13 
  WHEN '2' THEN TRUNC(SYSDATE)-7 
  WHEN '3' THEN TRUNC(SYSDATE)-8 
  WHEN '4' THEN TRUNC(SYSDATE)-9 
  WHEN '5' THEN TRUNC(SYSDATE)-10 
  WHEN '6' THEN TRUNC(SYSDATE)-11 
  WHEN '7' THEN TRUNC(SYSDATE)-12 
  END 
) AS PREV_YIELD,


you will have

PREV_Y(E.PERSON_ID) AS PREV_YIELD,


and the function:

CREATE OR REPLACE function PREV_Y(PERSON_ID number)
return NUMBER
IS
PREV_YIELD number;
begin
SELECT NVL(SUM(HOURS_WORKED)/DECODE((SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)),0,1,(SUM(HOURS_PER_WEEK)-SUM(LEAVE_HOURS)))*100,0) 
INTO PREV_YIELD
FROM APPS.YIELD_CALC 
WHERE PERSON_ID=YIELD_CALC.PERSON_ID 
AND START_DATE= 
    CASE TO_CHAR(SYSDATE, 'D') 
  WHEN '1' THEN TRUNC(SYSDATE)-13 
  WHEN '2' THEN TRUNC(SYSDATE)-7 
  WHEN '3' THEN TRUNC(SYSDATE)-8 
  WHEN '4' THEN TRUNC(SYSDATE)-9 
  WHEN '5' THEN TRUNC(SYSDATE)-10 
  WHEN '6' THEN TRUNC(SYSDATE)-11 
  WHEN '7' THEN TRUNC(SYSDATE)-12 
  END 
	return PREV_YIELD;
end PREV_Y;
/
Re: Materialized view creation with subquery [message #307706 is a reply to message #307704] Wed, 19 March 2008 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think that answering after 18 months is of any use.
Take newer topics to answer.

Regards
Michel
Re: Materialized view creation with subquery [message #307832 is a reply to message #190723] Thu, 20 March 2008 02:06 Go to previous message
drealecs
Messages: 2
Registered: March 2008
Junior Member
It might not help him but will help others that will have the same problem.
That's the forums ideas, isn't?
I miself was using a function and wanted to translate into a subselect subquery witch seems to be faster.
Previous Topic: Performance Issue in Query ?
Next Topic: How to store PDF file in CLOB datatype
Goto Forum:
  


Current Time: Tue Dec 06 04:42:18 CST 2016

Total time taken to generate the page: 0.10374 seconds