RE: select counts versus insert/select counts
- From: "Rob Dempsey" <Rob.Dempsey@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Oct 2007 13:13:00 +0100
I have seen different counts when there is an index on the table and
oracle has not maintained the index.
Check what the execution plan is. If it is using a index then try the
same SQL with a /*+ FULL(t)*/ hint
Rob
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
Sent: 18 October 2007 20:50
To: oracle-l@xxxxxxxxxxxxx
Subject: select counts versus insert/select counts
All,
I came across a rather strange situation a few days ago. One of our
developers wrote a simple sql script that inserted some rows into a
table. However, he was getting things that were not expected. He ran
just the select portion of the code and got a different number of rows.
Any thoughts on what it might be or what to search for?
We are running on AIX Version 5.2 with Oracle Database 10g Enterprise
Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options.
Thanks,
Michael
The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify me
immediately by replying to this message and deleting it and all
copies and backups thereof. Thank you.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
