Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Checking if more than 0 rows exist.

Re: Checking if more than 0 rows exist.

From: chao_ping <zhuchao_at_gmail.com>
Date: 10 May 2005 00:40:35 -0700
Message-ID: <1115710835.081070.24040@f14g2000cwb.googlegroups.com>

CHeck the plan. Oracle maybe doing full scan. Try to add /*+first_rows*/ hint and print the plan. Received on Tue May 10 2005 - 02:40:35 CDT

This message: [ Message body ]
Next message: Jeremy: "Re: Checking if more than 0 rows exist."
Previous message: DA Morgan: "Re: Excessive waits on 'SQL*Net message from client'"
In reply to: phil_herring_at_yahoo.com.au: "Re: Checking if more than 0 rows exist."
Next in thread: xhoster_at_gmail.com: "Re: Checking if more than 0 rows exist."

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US