The question was why would the system opened another copy of the same table after the code for indexing ran ? I fond out why, because I set the recordsourcetype property to table instead of alias by accident. Thank you all and sorry about the confusion.
sherry