Go Back > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 44

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 31st July 2004, 00:15
lesperancer lesperancer is offline
Junior Member
Join Date: Apr 2003
Posts: 9
lesperancer is on a distinguished road
Baan: baan4c2 - DB: sql server - OS: winNT
Can I add more indexes to baan sql server 7 tables

Baan 4c2

only indexes on current baan sql server tables are the hash fields
using ms-access to create management reports
some tables like tdsls051 has over 1 million rows and it takes 5 - 6 minutes for a query using this to run on the server

we've got a test baan server, and ran the same query after creating a index for a field used in my WHERE clause... it now runs in under 30 secs

I'd like to add indexes on the production server for this and other tables, but am not sure of its impact, if any, on baan ??
Reply With Quote
Old 31st July 2004, 18:02
gguymer's Avatar
gguymer gguymer is offline
Unconfirmed User
Join Date: Aug 2001
Location: Lufkin, Texas
Posts: 194
gguymer is on a distinguished road
Baan: Baan IVc4 SP12 - DB: Oracle 8i, 9i - OS: AIX 4.3, 5.3
We've added additional indexes for that same purpose to Baan tables with no problems. The only problem you would have was if you modified an existing index, but you're only wanting to add which again will not be a problem. Make sure that when you create the new index you check whether it should be a unique or non-unique index. Index1 on all Baan tables are created as unique, and usually all other indexes after the first one tend to be be non-unique. Index1 acts as a primary key. Hope this helps. We use Oracle, but the principles for most relational databases are the same.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.
Reply With Quote
Sponsored Links
Old 31st July 2004, 23:34
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
We have created additional indexes when we used to use SQL 7 (and now when we have SQL 2000) and they are fine.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone Having Problems Running Baan On Windows Server 2003 terryw Operating Systems & Databases 5 5th December 2006 06:02
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
BAANERP 5.0c and SQL Server 2000 installation isimeon Tools Administration & Installation 2 5th June 2003 08:18
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44

All times are GMT +2. The time now is 14:21.

©2001-2017 - -