Subject Re: unable to create index on .dbf having 30 fields and 100000 From Ken Mayer, dBase, LLC <kmayer@dbasellc.com> Date Wed, 1 Sep 2021 21:21:47 -0700 Newsgroups dbase.getting-started On 9/1/2021 8:31 PM, Milind Nighojkar wrote: > Hi Mevink, > Thanks > > I used your hint > use tablename exclusive > index on .... tag tagname > > it worked..... > > > Just to mention expression used is ltrim(rtrim(field1))+ltrim(rtrim(INV(field2)) which has length of around 40 chracters. > > YOu asked how much time did I wait...Actually I waited for 10 minutes when Dbase stopped its response. Then I have to kill the Dbase session . After restarting Dbase suprisingly index was available. It is generally a bad idea to trim fields used in indexes. It means that the values being searched for are different lengths, and can cause difficulties. If you remove the trims it might be a little faster, too. Ken -- *Ken Mayer*, dBase, LLC Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm