Tuesday, May 13, 2014

When is a table generated?

  • Generate a table after designing a new table or modifying an existing table by adding or removing columns. (*Note: Generating a table will drop and recreate the table which will remove all pre-existing data in the table). To ensure this data is not lost, you must export your data, generate the table, and then import it back in.  The changes need to be deployed to the server and client in a package.
  • When adding or changing indexes for a table there is no need to generate the table.  For an index change you can generate the indexes, and this will not affect the data stored in the table.

No comments:

Post a Comment

Featured Post

Generate single index on table 

Transaction tables such as F0911, F4111 etc hold a huge amount of data probably a third of petabyte. Generating indexes on such tables (th...

Popular Posts