Viewing 15 posts - 12,121 through 12,135 (of 26,486 total)
riya_dave, still waiting to see what kind of solution you came up with before I show you the four solutions I put together in 30 minutes.
Wayne showed you how to...
May 9, 2012 at 9:55 pm
WayneS (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
i got it,but anyhow i have to use while loop for condition
Okay, riya_dave, do you have a solution yet? I have 3 cursor-based solutions and...
May 9, 2012 at 9:34 pm
Depends if the data page needed for the query is in memory (cached) or not.
May 9, 2012 at 9:28 pm
Jeff Moden (5/9/2012)
Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.
Wow! Working with Oracle really did...
May 9, 2012 at 9:24 pm
Jeff Moden (5/9/2012)
Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.
Wow! Working with Oracle really did...
May 9, 2012 at 9:23 pm
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.
Edit: Cursor code removed. Sorry for the blasphemy.
May 9, 2012 at 4:33 pm
riya_dave (5/9/2012)
i got it,but anyhow i have to use while loop for condition
Okay, riya_dave, do you have a solution yet? I have 3 cursor-based solutions and a set-based solution...
May 9, 2012 at 4:31 pm
riya_dave (5/9/2012)
i got it,but anyhow i have to use while loop for condition
Why?
Take a break, let me ask you to solve the following hypothetical problem.
I own a company that makes...
May 9, 2012 at 3:58 pm
riya_dave (5/9/2012)
i remove cursor with while ,not improving still.what other i need to use in place of cursor
A WHILE loop is still row by agonizing row processing, just like a...
May 9, 2012 at 3:36 pm
You aren't going to improve the performance of your stored procedure until you eliminate the cursor(s) and implement set-based logic to accomplish what you are doing in your cursor row...
May 9, 2012 at 3:22 pm
Just walk away, just walk away, just walk away,...
Party at the TitD!!!
Someone please bring some hay for the guard hippo.
May 9, 2012 at 3:15 pm
Do your stored procedures filter the data from the views based on values based to the stored procedures, and only return the columns needed for that call?
If so, why not...
May 9, 2012 at 2:12 pm
You aren't going to get the help you need as long as you refuse to provide the information we need. Again, plesae read and follow the instructions in this...
May 9, 2012 at 2:07 pm
Putts (5/9/2012)
Lynn Pettis (5/9/2012)
Table --> View (or iTVF) --> stored procedure --> App
When you can do this:
Table --> stored procedure --> App
You haven't justified the need for...
May 9, 2012 at 1:29 pm
Sean Lange (5/9/2012)
Lynn Pettis (5/9/2012)
May 9, 2012 at 1:24 pm
Viewing 15 posts - 12,121 through 12,135 (of 26,486 total)