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 10:37:00 -0700 Newsgroups dbase.getting-started On 9/1/2021 10:25 AM, Miloind Nighojkar wrote: > Scenerio > Trying to create a index on .dbf file having more than 100000 records. > index key is having two fields. > Command iisued is index on ....to ...index file name... > observation is it hangs. > > when same file is used for recodrs say around 20000 it works... > > any suggestions..? > > Any changes expected in .ini file What exactly happens when you attempt this? It should be perfectly doable. Do you get an error? If so, can we get the exact wording of the error? 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