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!

Register Log in
  • Congratulations derfloh 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
  • Order by date
  1. RedInTheCorner

    Optimizer problem Oracle R1 versus R2

    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 :)
  2. RedInTheCorner

    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...
  3. RedInTheCorner

    Function based Indexes

    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.
  4. RedInTheCorner

    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...
  5. RedInTheCorner

    Need some help...

    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 :)
  6. RedInTheCorner

    Need some help...

    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....
  7. RedInTheCorner

    Need some 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
  8. RedInTheCorner

    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...
  9. RedInTheCorner

    Query help

    [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...

Part and Inventory Search

Back
Top