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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query taking too long - Hangs VB app
Nunina, It seems that VB is having trouble with the response volume. Assuming that your app is on a different box than Oracle, monitor its memory (physical and virtual) usage, to see how it handles the result sets. A very different approach would be to create a stored package, and activate it...- akshay127
- Post #2
- Forum: Oracle: All versions
-
How to speed up performance of a Delete statement
I take it that the parent table is TINST_FIN, and TINST_BR is the dependent table. Although you added only one parent record with no children, deleting a parent means checking all children, just to be sure. Thus you could temporarily disable/drop this constraint! This is of course only...
