Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: index returns wrong rows

Re: index returns wrong rows

From: Kenneth C Stahl <kcstahl_at_ix.netcom.com>
Date: Thu, 24 Jun 1999 20:09:38 -0400
Message-ID: <3772C8C2.8D020D4A@ix.netcom.com>


show us your sql and show us the statements which created the indexes.

macintosh_at_columbus-group.com wrote:
>
> I have several indexed tables in a database. The problem that I am
> having is that in some instances, the index is pointing to rows that it
> shouldn't be. (eg. if my index is pointing to all rows where
> group_num=4, it will point a some row where group_num is not 4). I'm
> running the exact same application on two different servers. One works
> fine but I am having this problem with the other. One server has Oracle
> 7.3.2.2 and the other has 7.3.4.4
>
> Any ideas whats going on?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jun 24 1999 - 19:09:38 CDT

Original text of this message

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