DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Long Running Querry

Threaded View

  1. 10-23-2003, 12:41 PM #1
    pascal01
    pascal01 is offline Member
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222

    Unhappy Long Running Querry

    Hi, I have a long running querry which returns 59k rows in 25 minutes. The querry is doing a select on a view and in the view I am joining 3 tables. I am using the RULE based optimizer and I tried analysing tables and using the CBO. It still takes 25 minutes. I tried using various hints without much luck. The TKPROF shows that no FULL table scans is being done. Please see attached TKPROF.
    Couls someone please guide me in the right direction. Thanks.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width