<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/dba/ttdba0130s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Storage Parameters Optimization (ttdba0130s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to maintain the storage parameters for database tables and indexes in a specific database. With this session you can optimize the storage driver parameters for a specific database to improve the performance between Infor ERP LN and the database.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">The storage parameter file provides a way to specify the distribution of the table and index data in different tablespaces. Storage parameters are used by the database driver when a <Link href="/baanerp/tt/glossary/glossary#dll.tt" role="glossary">Dynamic Link Library</Link> statement, for example, a create table or create index statement is executed.</Paragraph>
		</GeneralSection>
		<ExampleSection><SectionTitle>
                                 Example
                              </SectionTitle>
			<Paragraph class="Default">Tfgld402:312:T:TABLESPACE baan INITIAL 500M NEXT 200M *:*:*: TABLE SPACE baan</Paragraph>
			<Paragraph class="Default">In this Oracle example, the database driver adds the clause TABLESPACE baan to the create statement during the creation of the table or index. As a result the table tfgld402 in company 312 is created with a different size than the other tables in the database.</Paragraph>
			<Paragraph class="Default">The database storage parameters are defined by the database driver implementation and often map to the table and index creation option, which are available in the database. There are several driver configuration options that allow the user to customize the table and index attributes. These storage options effect the specified tables in the database</Paragraph>
		</ExampleSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><DocRef>Infor Enterprise Server - Technical Reference Guide for Informix Database Driver (U8781 US)</DocRef>
			</RelTopic>
			<RelTopic><DocRef>Infor Enterprise Server - Technical Reference Guide for Microsoft SQL Server Database Driver (U8173 US)</DocRef>
			</RelTopic>
			<RelTopic><DocRef>Infor Enterprise Server - Technical Reference Guide for DB2 Database Driver (U7829 US)</DocRef>
			</RelTopic>
			<RelTopic><DocRef>Infor Enterprise Server - Technical Reference Guide for Oracle Database Driver (U7076 US)</DocRef>
			</RelTopic>
			<RelTopic><DocRef>Infor Enterprise Server - Technical Reference Guide for MySQL Database Driver (U8924 US)</DocRef>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
</Session>
