• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Rebuilding Indexes

condor

Member
Hi.. I need to rebuild the indexes for three tables, but I'm not sure the correct way to do it.

Can somebody give an advise.

Thanks

Jorge
 

Christian Audet

Moderator
Staff member
Jorge,

What is your version ?

There is a option to generate all indexes on a table called "Generate Indexes" that can be used without loosing any data. Be carefull not to use the "Generate Table" because you will loose every data in this table.

Give me your version and I will give all the steps to do it.

Christian Audet


Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

condor

Member
Hi Christian:
I'm using Xe SP15.1, SQL 2k and Win 2k. I know about Generate Index options but I was not sure if its works to recreate indexes or just o create them.
Please advise me.
Thanks
 

libbi_fletcher

Well Known Member
We had to do that and we used Object Librarian, checked out the table, click
on generate indexes (NOT TABLES) on the menu bar, check it back in. We did
ours in CRP environment first of course.

Libbi Fletcher
HoMedics, Inc.
M.I.S. Department
248-863-3001 ext. 1281
libbi.fletcher@homedics.com
 

Zoltan_Gyimesi

Legendary Poster
Hi Condor,

The Generate Index works. We also have a similar system than yours except OW SP level. Ours is SP 14.

You have to generate your indecies in each data source where they reside (e.g. in each Business Data - PROD, CRP, DEV etc.)

You have to fill the password field. It is generally the same as the data source name, appeared in a grayed out field above the password field.

BE CAREFULL, Generate Index and NOT!!!!! Generate Table!!!!!
Their forms are indentical except the Form Title. Check everything twice before hit the OK.

At last but not least, You Are Welcome on the JDEList Forums/Lists.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Christian Audet

Moderator
Staff member
Jorge,

Since you know about the generate index I will not give you all the step (tell me if you required them).

About the "generate index" YES it's working to recreate the indexes.

look at this text from my log when I use the option on F0101.

===================================================================
DROP INDEX F0101_1 ON F0101
CREATE UNIQUE INDEX F0101_1 ON F0101 (ABAN8 ASC)
CREATE INDEX F0101_2 ON F0101 (ABDC ASC)
CREATE INDEX F0101_3 ON F0101 (ABALKY ASC)
CREATE INDEX F0101_4 ON F0101 (ABTAX ASC)
CREATE INDEX F0101_5 ON F0101 (ABAT1 ASC, ABDC ASC)
CREATE INDEX F0101_6 ON F0101 (ABAC01 ASC, ABAC04 ASC, ABDC ASC)
CREATE INDEX F0101_7 ON F0101 (ABAC01 ASC, ABAC03 ASC, ABDC ASC)
CREATE INDEX F0101_8 ON F0101 (ABAC01 ASC, ABAC02 ASC, ABDC ASC)
CREATE INDEX F0101_9 ON F0101 (ABAC01 ASC, ABDC ASC)
CREATE INDEX F0101_10 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABAC04 ASC, ABDC ASC)
CREATE INDEX F0101_11 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABAC03 ASC, ABDC ASC)
CREATE INDEX F0101_12 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABAC02 ASC, ABDC ASC)
CREATE INDEX F0101_13 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABDC ASC)
===================================================================

So Jorge,

No there is not any problem to use this option to RECREATE indexes.

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

vchai

Active Member
What is the difference between reindexing using SQL Server's Enterprise
Manager and using OMW to reindex a table?


Vincent Chai
Xe, SQL 7, Win 2000



--------------------------
 

Carl_Fisher

Well Known Member
Two approaches -

1) talk to your Database Administrator - he will be able to do it using
database tools.

2) OMW - Table Operations - Generate Indexes, this should drop and recreate
all indexes on a table, may take a while for a Large table, best done
offline. BEWARE - do not select Generate Table - this will Dump all your
data!!!


OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development
 
Top