CREATE MATERIALIZED VIEW cust_sales_mv
tablespace claims_5m
BUILD IMMEDIATE
REFRESH COMPLETE on demand with rowid
disable QUERY REWRITE
AS
SELECT c.claim_number,
c.status,
c.date_received ,
aag.state,
p.pay_amount
FROM claims.ardis_ac tive_groups aag,
claims.claim c,
claims.payment p
WHERE aag.GROUP_ID = c.GROUP_ID
AND c.claim_seq = p.claim_seq...
rahulkumar
Last Activity: Aug 1 '11, 03:12 PM
Joined: Jul 16 '11
Location:
-
Materialized view creation taking too long
-
Please let me know how can i improve performance of my query.
Do you think partition would work since there are millions of rows in each table -
Can anybody tell me how do i do partitioning for my query since the data is very hugeLeave a comment:
-
I've already removed distinct but the query is still running very slow.
Explain Plan for the Query:
Explain plan for the query:
SELECT STATEMENT FIRST_ROWS Cost: 3.1410120922418 6944E23 Cardinality: 1.0167231070836 8992E27 IO Cost: 3.1410120922418 6944E23
31 SORT UNIQUE NOSORT Cost: 3.1410120922418 6944E23 Cardinality: 1.0167231070836 8992E27 IO Cost: 3.1410120922418 6944E23
30...Leave a comment:
-
...Code:Alter table claims.claim drop primary key cascade; drop table claims.claim cascade constraints; create table claims.claim ( claim_form_seq number(18), claim_number varchar2(40 byte), correspondence_required varchar2(1 byte), status varchar2(3 byte), total_charge number(9,2),
Leave a comment:
-
How to improve performance on query
Please suggest me a better alternative for this query to reduce execution time.
...Code:SELECT DISTINCT claim_number, status, date_received, pay_amount FROM (SELECT c.claim_number, c.status, c.date_received, p.pay_amount FROM claims.ardis_active_groups aag, claims.claimLast edited by Niheel; Jul 18 '11, 12:40 AM.
No activity results to display
Leave a comment: