Hi All, I have some rbase apps that are running a little bit slower than I would like. The lines of code that are slow, are updates to some very large tables. For example, I may want to update a column called flag on every line where the column client_id = 1234 and there are 1000 lines out of a million lines that meet that criteria. Even though I have an index on the column client_id, it still takes a few seconds. I created a temporary view, single table, and restricted it to just the rows with the client_id of the current client. All my changes are now much faster and appear to be being updated in the source table. Is the use of a temporary single table view the best choice? Mike
