How Do You Can Prevent And Remove Fragmentation ?

1.	How Do You Can Prevent And Remove Fragmentation ?
Answer» You can PREVENT and remove fragmentation: 1. To prevent fragmentation, optimize data loads by sorting load records based upon sparse dimension MEMBERS. For a comprehensive discussion of optimizing data load by grouping sparse members. 2. To remove fragmentation, PERFORM an export of the database, delete all data in the database with CLEARDATA, and RELOAD the export file. 3. To remove fragmentation, force a dense restructure of the database. You can prevent and remove fragmentation: 1. To prevent fragmentation, optimize data loads by sorting load records based upon sparse dimension members. For a comprehensive discussion of optimizing data load by grouping sparse members. 2. To remove fragmentation, perform an export of the database, delete all data in the database with CLEARDATA, and reload the export file. 3. To remove fragmentation, force a dense restructure of the database.

Answer»

You can PREVENT and remove fragmentation:

1. To prevent fragmentation, optimize data loads by sorting load records based upon sparse dimension MEMBERS. For a comprehensive discussion of optimizing data load by grouping sparse members.

2. To remove fragmentation, PERFORM an export of the database, delete all data in the database with CLEARDATA, and RELOAD the export file.

3. To remove fragmentation, force a dense restructure of the database.

You can prevent and remove fragmentation:

1. To prevent fragmentation, optimize data loads by sorting load records based upon sparse dimension members. For a comprehensive discussion of optimizing data load by grouping sparse members.

2. To remove fragmentation, perform an export of the database, delete all data in the database with CLEARDATA, and reload the export file.

3. To remove fragmentation, force a dense restructure of the database.

How Do You Can Prevent And Remove Fragmentation ?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment