Buddy, It kills the system,performance is royally screwed,be carefull before adding one more.
On Wed, Nov 3, 2010 at 3:10 PM, Siddaiah BB <[email protected]> wrote: > 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 > -- Thanks & Regards Sharath + 91 9902434804(India) -- 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
