Ini_trans for indexes

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 17 Oct 2002 11:27:52 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702CC6BED@lnewton.leeds.lfs.co.uk>

Hi Ashok,

I asked this very same question some time ago, and the general opinion was index should be one higher than the table.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


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

-----Original Message-----
From: ashok_jayaraman_at_yahoo.com (Jayaraman Ashok) [mailto:ashok_jayaraman_at_yahoo.com]
Posted At: Thursday, October 17, 2002 4:08 AM Posted To: server
Conversation: Ini_trans for indexes
Subject: Ini_trans for indexes

Hi
The default value for ini_trans is 1 for tables and 2 for indexes/clusters. Now when we expect the number of concurrent inserts on a table to be around 30 , if the ini_trans is set to 20,then should the ini_trans for the index be set to 40 or 21 ? Is there a rule that the ini_trans for index should be twice that of the table ? If so, why ? Will this also result in increasing the space occupied by the block header ?

Cheers,
Ashok Received on Thu Oct 17 2002 - 05:27:52 CDT