INITRANS on indexes

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 2 Oct 2001 11:28:31 +0100
Message-ID: <F43F5B4264AED511A10F0008C7DBB606155CE4@leuler.leeds.lfs.co.uk>

Quick question - hopefully,

I have a table with INITRANS set to 5
What should be the INITRANS setting on the tables index(es) and why ?

I know that the default is one for a table and two for an index because the index transactions are serialised and therefore need one extra slot. Does this mean that the table above will need its indexes set to INITRANS 10, or just 6 ?

Thanks in advance.

Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

Received on Tue Oct 02 2001 - 05:28:31 CDT