Performance with Cursors

From: Larry <graypoopawn_at_hotmail.com>
Date: 1 Mar 2002 10:37:35 -0800
Message-ID: <ec40136c.0203011037.6f1aaefb_at_posting.google.com>

Has anyone ever had a sever performance degrade as a result of cursors being used instead of a huge sql statement? Currently, I am using a cursor and then fetching 3 other values by using select into statements and performance is very slow...

Thanks. Received on Fri Mar 01 2002 - 19:37:35 CET

This message: [ Message body ]
Next message: Neothinker: "How to control width of column headers on select"
Previous message: RKG: "Re: Oracle Reports?"
Next in thread: Ashish Mittal: "Re: Performance with Cursors"
Reply: Ioannis Xanthopoulos: "Re: Performance with Cursors"
Reply: Ashish Mittal: "Re: Performance with Cursors"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message