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
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)
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
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
[email protected]
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
[email protected]
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)
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)
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)
condor
Member
Thanks to everybody.
I feel safe now.
I feel safe now.
libbi_fletcher
Well Known Member
It regenerates indexes on files when you think that is necessary. We did
F0911, F0902 and F0901 in CRP environment. We had performance issues.
Libbi Fletcher
HoMedics, Inc.
M.I.S. Department
248-863-3001 ext. 1281
[email protected]
F0911, F0902 and F0901 in CRP environment. We had performance issues.
Libbi Fletcher
HoMedics, Inc.
M.I.S. Department
248-863-3001 ext. 1281
[email protected]
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
--------------------------
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
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
Similar threads
- JohnABleich
- JD Edwards® EnterpriseOne Developers
