checks and rebuilds indexes after a cross-platform database load where the endian types are different.
sp_post_xpload
Once the database is loaded from another platform, rebuild its indexes by executing:
sp_post_xpload
None.
Can be only executed by a System Administrator.
The following indexes are rebuilt on all user tables in the database:
Nonclustered index on an APL table
Clustered index on a DOL table
Nonclustered index on a DOL table
Indexes on system tables are not processed with this stored procedure. System table indexes are rebuilt when online database is executed.
You can also rebuild indexes using drop index and create index.
Only run this stored procedure when the database is loaded across platforms with different endians.
Where the index status is suspect, reset the index by executing the sp_xpload, drop index, or create index.
Stored procedures are recompiled from the SQL text in syscomments at the first execution after the load database. Use dbcc upgrade_object to upgrade objects if you do not have permission recompile from text.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
