Re: help:tkprof exlpain returns 0 rows

• Post for FREE via your newsreader at post.usenet.com ****

Hi Joe

> What I did was wrong?

If the TKPROF output doesn't contain an execution plan entitled "Row Source Operation", the information about the execution plan and therefore the amount of rows selected by each operation is missing in the tracefile (it usually happen because the cursor has not been closed). Otherwise, you probably executed the statement in parallel.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=