Skip to Content
Former Member
Dec 31, 2008 at 01:21 AM

Update databse from internal table statement not using index


Hi Guys,

We are updating a databse table from a file. The file has a couple of fields which have data different from what the database has (non-primary fields :). We upload the file data into an internal table and then update the database table from internal table. At a time, internal table is supposed to have 10,000 records. I did SQL trace and found that the update statement is not making use of the databse index.

Should not the update statement here be using the table index (for primary key)?