The following are few methods to Optimize the Workspace.
- When adding lookup column, ensure that the reference column in the parent table contains unique data.
- When you set Import Type to UPDATE ADD for uploading data into an existing table, you need to specify one or more matching columns based on which the existing records in the table will be matched. Specify column which contains unique data as matching columns.
- When you use Join clause in Query table, then the where clause should satisfy the following criteria.
- One of the column in the Join clause should contain unique data.
- Date column should not be used directly in the Join clause. Convert the date data into string using the Concatenation {concat(Column_Name)} formula.
- Do not use any function over the column in join clause. Create a formula column with the required function and then use this new column in the Join clause.