Output is very slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Output is very slow

  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Output is very slow

    i am using oracle 9i with windows 2000 server
    nearly 50 users are using this server

    I am having table "Pp_Receive_Detail_Trn" contain 8 lakhs records

    if i am executing this qury

    select SUM(Pp_Receive_Detail_Trn.Received_Pieces),
    Pp_Receive_Detail_Trn.Process_Fk,Pp_Receive_Detail_Trn.Factory_Tbl_Fk
    from Pp_Receive_Detail_Trn
    where
    to_date(Pp_Receive_Detail_Trn.Prod_Rec_Date,'DD/MON/YY') >= '01/MAR/06' AND
    to_date(Pp_Receive_Detail_Trn.Prod_Rec_Date,'DD/MON/YY') <= '11/MAR/06'
    group by Pp_Receive_Detail_Trn.Process_Fk,Pp_Receive_Detail_Trn.Factory_Tbl_Fk

    it is taking nearly 10 secs

    this is very slow for our process...

    all the fields i have indexed

    pls give solution for this
    for coming result with speed

    If any database parameters i have to check pls tell me ???

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    whats the explain plan, have you traced it to find what you are waiting on?

    plus hardly anyone where will know what a 'lakh' is

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width