Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > db2 > answers

Fetch command in cursor is very slow....

  #1  
Old June 18th, 2009, 12:45 PM
Newbie
  
Join Date: May 2009
Posts: 2
Hi All,

I have a static cursor in my procedure and is running very slow.

actually its very fast to open the cursor but taking long time to fetch the each row.

Any ideas to improve the fetch command faster.

Regards
Antony
  #2  
Old July 18th, 2009, 11:06 PM
Newbie
  
Join Date: Jul 2009
Location: India
Posts: 2

re: Fetch command in cursor is very slow....

Maybe you can try to see the matchcols for your query and try to improve/change the index if match cols is 0.
Reply

« previous question | next question »

Similar Threads
Thread Thread Starter Forum Replies Last Post
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 5 November 14th, 2005 12:36 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 14th, 2005 04:15 AM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 11:37 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 09:56 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 03:15 AM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved