Hi Sybase Experts,
We have a requirement to move Sybase ASE 188.8.131.52 (30 databases) from HP-UX to AIX (as per very specific requirements). We plan to use BCP for tables / data migration. Post data migration we need to created/build indexes. The database is huge with about 3TB data in approx 10000 In our test environment, it took 2 min to rebuild index with 1million rows (HP-UX OS). We have tables with 10million to 35 million rows.tables and 15000 indexes. There are about 150 cluster indexes as well. We need inputs on time required to build indexes after performing BCP operations for data migration as we have downtime only over weekend.
Would you please share your experiences about time required to create index for a table with a million rows (about 1GB data size) on AIX - Sybase ASE version 184.108.40.206. What are the options to speed up index creation / building parallelism to achieve data migration over weekend's downtime?
Thanks for your time and suggestions!