Hi , is there any limitations in creating indexes to jBase file. what is the disadvantaged of creating more number of index records for a single file.
Thanks & Regards, Siddaiah On Wed, Oct 27, 2010 at 1:59 AM, Mohankumar Balasubramaniam < [email protected]> wrote: > 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 > -- 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
