| lobindex & partitioned table [message #158172] |
Wed, 08 February 2006 16:29 |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
I created a partitioned table with a CLOB column in which the lobindex SYS_IL0000013677C00026$$ was created as a result. I then loaded the data into the new table. Once this was accomplished and all indexes were inserted and verified (other portions of the application verified the other indexes), the client complained of slowness with displaying the data in the new CLOB column. These partitions all display a status of 'USABLE' for the lobindex, leading me to believe that the lobindex is valid & usable. What are the performance gains/losses with my current setup? Is it detrimental to have a lobindex partitioned?
SQL> select index_name, partition_name, status from user_ind_partitions where index_name = 'SYS_IL0000013677C00026$$';
INDEX_NAME PARTITION_NAME STATUS
------------------------- ------------------------------ --------
SYS_IL0000013677C00026$$ SYS_IL_P72 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P73 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P74 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P75 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P76 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P77 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P78 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P79 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P80 USABLE
SYS_IL0000013677C00026$$ SYS_IL_P71 USABLE
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
