Home » RDBMS Server » Performance Tuning » Analyze SYS_IL0000 LOB Indexes
icon14.gif  Analyze SYS_IL0000 LOB Indexes [message #203029] Mon, 13 November 2006 10:56 Go to next message
venkatp6
Messages: 1
Registered: November 2006
Location: 1899 L Street NW, 7th Flo...
Junior Member
How to analyze LOB segment SYS_IL000 indexes?

-Venkat

Report message to a moderator

Re: Analyze SYS_IL0000 LOB Indexes [message #203042 is a reply to message #203029] Mon, 13 November 2006 12:18 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4005.htm#SQLRF01105
Quote:
You cannot compute or estimate statistics for the following column types: REF column types, varrays, nested tables, LOB column types (LOB column types are not analyzed, they are skipped),

Report message to a moderator

Previous Topic: Index not used in outer join query
Next Topic: Query Optimization problem...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 12:40:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.