Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Table design considerations

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
Antonio Barata
Warnings : 1
New User


Joined: 04 Apr 2007
Posts: 37
Location: Lisbon, Portugal
PostPosted: Thu Jul 10, 2008 12:11 am    Post subject: Table design considerations
 Reply with quote
Hi
Where can I find some information on how to create tables, in terms of performance and efficiency?
I want to know what columns should I put first:
The indexes? The ones more often used?
I have been looking at IBM's manuals and couldn't find anything.
Back to top
View user's profile Send private message
References
stodolas

Senior Member


Joined: 13 Jun 2007
Posts: 647
Location: Wisconsin
PostPosted: Thu Jul 10, 2008 8:18 am    Post subject:
Reply with quote
The performance difference from column order can usually be measured as negligible.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1