Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 31st July 2004, 01: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

running
NT4 SP6
SQL SERVER 7
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
Sponsored Links
  #2  
Old 31st July 2004, 19: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
  #3  
Old 1st August 2004, 00:34
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
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
Reply


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 07:02
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49
BAANERP 5.0c and SQL Server 2000 installation isimeon Tools Administration & Installation 2 5th June 2003 09:18
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44


All times are GMT +2. The time now is 13:18.


©2001-2017 - Baanboard.com - Baanforums.com