Home » RDBMS Server » Performance Tuning » Index storage
Index storage [message #65592] Wed, 03 November 2004 21:29 Go to next message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi,

I have been given a task of specifying storage parameters for Indexes.Can anybody suggest me a checklist that will tell me to specify optimal storage parameters for an Index.

What are the things that I should keep in mind before specifying the storage parameters for an Index.

Pls. this is urgent.

Thanks in Advance.

Milind.

Report message to a moderator

Re: Index storage [message #65598 is a reply to message #65592] Thu, 04 November 2004 02:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
USE LMT ( local managed tablespaces) for indexes (and tables and everything else), use uniform extents. FORGET the storage clauses and other dictionary managed concepts.

Report message to a moderator

Re: Index storage [message #65630 is a reply to message #65598] Wed, 17 November 2004 16:57 Go to previous message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi Mahesh,

Thanks for your help but the problem is we have been recommended that we will be using DMT in our environment and therefore optimal storage parameters are to be specified for the Indexes.

Pls. suggest me to findout the optimal value for INITIAL EXTENT parameter for the Indexes.

thanks in Advance

Milind.

Report message to a moderator

Previous Topic: about EVENT TRACE
Next Topic: 10046 - Unable to trace JDBC thin client
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:47:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.