Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Submitted by: AdministratorThere are several ways to do this:
1) We can move the table in the same or other tablespace and rebuild all the indexes on the table.
alter table <table_name> move <tablespace_name> this activity reclaims the defragmented space in the table
analyze table table_name compute statistics to capture the updated statistics.
2)Reorg could be done by taking a dump of the table, truncate the table and import the dump back into the table.
Submitted by: Administrator
1) We can move the table in the same or other tablespace and rebuild all the indexes on the table.
alter table <table_name> move <tablespace_name> this activity reclaims the defragmented space in the table
analyze table table_name compute statistics to capture the updated statistics.
2)Reorg could be done by taking a dump of the table, truncate the table and import the dump back into the table.
Submitted by: Administrator
Read Online Ab Initio Job Interview Questions And Answers
Top Ab Initio Questions
| ☺ | How do you convert 4-way MFS to 8-way mfs? |
| ☺ | What is skew and skew measurement? |
| ☺ | What is local and formal parameter? |
| ☺ | What is the difference between rollup and scan? |
| ☺ | What does dependency analysis mean in Ab Initio? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
