index build for z0102

• Article Type: General
• Product: Aleph
• Product Version: 15.2

Description:
The index built for z0102_id1 was set off. We were expecting this to be much quicker. None of the browse indexes are working in the catalogue subsets, so this is causing major difficulty in the Reading Rooms.

Resolution:
The z0102_id1 index occupies around 22,000 extents. This is because each extent is defined as 1MB. It certainly may have taken longer than usual to build because of this but, according to Oracle documentation, it should not present a performance problem in current usage.

However, in case you have to rebuild z0102 in the future, it would be better to change file_list and define this index in tablespace TS9X, with initial allocation 1000M (same as z0102_id). Then, according to TS9X definition (next extent 100M) you would have a little over 200 extents.

But if you do it, you must remember beforehand to check that you have the necessary 22GB free in TS9X !!