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

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 5

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
Old 31st July 2004, 23:34
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Join Date: Mar 2002
Location: Malvern, England
Posts: 310
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
Sponsored Links

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 16:30.

©2001-2018 - -