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
