Pearl Jabm
Active Member
Hi everybody.
I noticed that most of my users go to P4310 and run querys with fields that are not included oin the primary key. I was wondering about creating a new index with all those fields so the query will take less time to be acomplished. From OMW I can regenerate the index and I been told that creating indexes from the DBMS (SQl server in my case) is not recommended by JDE/PeopleSoft/Oracle/Anything...
My questions ... Have you guys done this without further troubles in operation?
Thanks.
I noticed that most of my users go to P4310 and run querys with fields that are not included oin the primary key. I was wondering about creating a new index with all those fields so the query will take less time to be acomplished. From OMW I can regenerate the index and I been told that creating indexes from the DBMS (SQl server in my case) is not recommended by JDE/PeopleSoft/Oracle/Anything...
My questions ... Have you guys done this without further troubles in operation?
Thanks.