Search results for query: *

Thanks, I tried it before it didn't solve my problem. I think problem reason was in 10gR1 oracle first sort analytic queries in view and then filter them. However in 10gR2 oracle first filter with view and then sort it. I solved problem by writing a query with out analytic functions :)

I have two different exucution plan for same query, first one runs in 12 sec and the other run in 0.15 sec. Basic difference is one database is 10gR1 and the other one is 10gR2, I encounter that problem in every queries that include YH_HASTA_YATIS_SURECLERI VIEW, it is a view with analytic...

Errors was ORA-03113 and ORA-03114, Many thanks, I solved the problem. Some of the rows have same A and B values for Status 'T' A B Status 1 2 'T' 1 2 'T' Thats why I cannot create a unique index and oracle crashs :(. I update old data and re-create index.

I want to use function based index below, but when I tried to crate index, I got following errors; ORA-03113 and ORA-03114, CREATE UNIQUE INDEX Ndx_XTableonAB ON XTable (CASE WHEN Status = 'T' THEN A END, CASE WHEN Status = 'T' THEN B END) TABLESPACE NUCL_NDX STORAGE (INITIAL 128K NEXT 128K...

Sory Dagon I really didn't know awarding issue :( I am a newbie in this forum and I don't like reading forum rules and features. And Kencunningham thank you too, I give you a star too :)

Owww My Query is not working rite I little bit simplifed your query and use it, it is really great and genious :) Thanks for your help....

thanks it is a good solution but it is little bit advanced for me :P I usually like simple queries... It is working perfect but little bit hard to memorize... Anyway still I am on behind of my self-join query till I find a better one or learn Oracle's Analytic functions :P

Hello everyone, I have little bit problem with a query. Query's aim is getting max number of intersections of processes. My table is PROCESS_TEST Process StartDate EndDate 1 01/02/2006 02/03/2006 2 04/02/2006 07/03/2006 3 05/02/2006 08/0372006 4 03/01/2006...

[deleted]...I also created a unique index on all four primary key columns, but result remain the same. How can I reduce the execution time. Any suggestions will be highly appreciated.... [deleted] Hi Al, When you have a PRIMARY KEY in oracle you already have a Unique index on pirmary key's...