RE: index doesn't contain duplicates

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 9 Jun 2009 13:22:03 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A903E937D4_at_usahm208.amer.corp.eds.com>

Yes, the full Oracle version would be nice plus the select with plan the produces the proper results and one that does not.  

Things you can try:  

Run analyze index validate
Run analyze table validate cascade (depending on results from above) Drop and re-create index  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Josh Collier

	Sent: Tuesday, June 09, 2009 12:11 PM
	To: oracle-l_at_freelists.org
	Subject: index doesn't contain duplicates
	
	

	All,

	 

	I have an table that has duplicate values for a column. I have a

non-unique index on this column. When I run a query that uses a fast full scan to retrieve the rows, it only retrieves one of the two rows. When I force a full tablescan both of the rows come back. I have used all my sql tricks to try my best to determine if the value has trailining or leading non-printable characters and it doesn't appear so. I have also moved the values into a varchar 11 field in another table, the value is 11 chars long. Both of the duplicate rows where accepted. Does anyone know of a bug or a reason why both of the rows wouldn't appear in the index?          

        Thanks for your time,

        Josh C.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 09 2009 - 12:22:03 CDT