Hi James, You'll notice a huge difference in performance if you do. In the absence of an index, SQL will perform a table scan each time you try to do a lookup.
Best regards, Christoph --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" <[EMAIL PROTECTED]> wrote: > > Hi everyone > > If I have a table with only 2 fields (say Item and Pallet Id) and I have > about 100,000 records should I bother to have any indexes? > I use this table only in one script for data migration > > The script runs through the records ordered by item and another script does > a lookup by pallet id > > Thanks > James > > > > [Non-text portions of this message have been removed] >