Hi Seshu, Can you check the first select statement? please check is there any record with value in field *RECOMMEND. I think all records have null value in RECOMMEND field. thats why you are getting no records selected.*
** Regards, Mohan On Tue, Oct 26, 2010 at 7:53 AM, Sesh <[email protected]> wrote: > Hi, > > What is the exact purpose of creating external indexes ? > > When there is a external index for some type of fields with IN2 return > wrong record counts on select commands in oracle databse. > > > *SECURITY.MASTER - * RECOMMEND field is having problem while selecting in > Oracle database. > > > > *After creating the index fo the field RECOMMEND, the SELECT statements > behaviour are shown below* > > *SELECT F.SECURITY.MASTER WITH RECOMMEND NE ‘’ – should return 1 records > selected instead it gave No records selected* > > *SELECT F.SECURITY.MASTER WITH RECOMMEND EQ ‘’ – should return 16416 > records selected instead showing 16417 selected* > > *SELECT F.SECURITY.MASTER WITH RECOMMEND EQ ‘BUY’ – returning 1 records > selected – which is correct. * > > *Dictionary record for the field RECOMMEND – It’s right justified in SS.* > > ** > > *Regards,* > > *Sesh.* > > > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
