Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: RedInTheCorner
- Content: Threads
- Order by date
-
Optimizer problem Oracle R1 versus R2
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...- RedInTheCorner
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Function based Indexes
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...- RedInTheCorner
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
Need some help...
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...- RedInTheCorner
- Thread
- Replies: 6
- Forum: Oracle: All versions
