Hey Listers!!!

Happy (insert desired greeting here)!!

ARS 4.5.2

Hopefully, this is a quick question- We have been having issues with Indexed
Fields, specifically after permissions are changed (very tricky problem). I
was trying to find a way to locate all of our Indexed fields to have a list
of fields (which would help in quickly locating the problem in the future)
and as well, determine if we really do need those indexed (I inherited the
Admin position a while ago and have been in perpetual cleanup ever since). I
looked in the Admin Tools, specifically the Analyze, but couldn't find
anything for the Indexes. I also checked the Form Properties, however, this
only lists Fields that were indexed through the Form Properties, and not
Fields that were Indexed through the Field Properties /Database tab.

Does anyone know how to quickly and easily locate all Indexed fields in a
given system?

Thanks SOO much in advance!!!
Shawn


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
What database are you using?

Shawn Stonequist wrote on 12/29/2004, 10:34 AM:


Hey Listers!!!



Happy (insert desired greeting here)!!



ARS 4.5.2



Hopefully, this is a quick question- We have been having issues with Indexed Fields, specifically after permissions are changed (very tricky problem). I was trying to find a way to locate all of our Indexed fields to have a list of fields (which would help in quickly locating the problem in the future) and as well, determine if we really do need those indexed (I inherited the Admin position a while ago and have been in perpetual cleanup ever since). I looked in the Admin Tools, specifically the Analyze, but couldn't find anything for the Indexes. I also checked the Form Properties, however, this only lists Fields that were indexed through the Form Properties, and not Fields that were Indexed through the Field Properties /Database tab.



Does anyone know how to quickly and easily locate all Indexed fields in a given system?



Thanks SOO much in advance!!!

Shawn

This posting was submitted via the Web interface

Oracle 8i or 9i (we are in the process of upgrading and I don't reemmber if
our DBA has gotten to our remedy db yet)

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Frank Caruso
Sent: Wednesday, December 29, 2004 9:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Finding Remedy 4.5.2 Indexed Fields


** What database are you using?

Shawn Stonequist wrote on 12/29/2004, 10:34 AM:

Hey Listers!!!

Happy (insert desired greeting here)!!

ARS 4.5.2

Hopefully, this is a quick question- We have been having issues with
Indexed Fields, specifically after permissions are changed (very tricky
problem). I was trying to find a way to locate all of our Indexed fields to
have a list of fields (which would help in quickly locating the problem in
the future) and as well, determine if we really do need those indexed (I
inherited the Admin position a while ago and have been in perpetual cleanup
ever since). I looked in the Admin Tools, specifically the Analyze, but
couldn't find anything for the Indexes. I also checked the Form Properties,
however, this only lists Fields that were indexed through the Form
Properties, and not Fields that were Indexed through the Field Properties
/Database tab.

Does anyone know how to quickly and easily locate all Indexed fields in a
given system?

Thanks SOO much in advance!!!
Shawn
This posting was submitted via the Web
interface


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
Not sure what you mean by indexed through field properties but you should see all of the indexes created through the Remedy admin tool on the Form Properties tab. If indexes were created at the database level you will need your DBA to give you a report by table listing those indexes. However, it will be a little difficult to understand as the report will be the field ID's not the names. If you have a copy of TOAD you can find a lot of this information yourself. (www.toadsoft.com)

A good starting point might be to figure out the largest tables in your application and check all of those indexes first. Smaller tables -records less than a few thousand - won't require as much indexing. Also, make sure your DBA is running STATS regularly. This can have a huge impact on your larger tables.

Hope that helps

Shawn Stonequist wrote on 12/29/2004, 11:11 AM:


Oracle 8i or 9i (we are in the process of upgrading and I don't reemmber if our DBA has gotten to our remedy db yet)



-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Frank Caruso
Sent: Wednesday, December 29, 2004 9:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Finding Remedy 4.5.2 Indexed Fields


** What database are you using?

Shawn Stonequist wrote on 12/29/2004, 10:34 AM:


Hey Listers!!!



Happy (insert desired greeting here)!!



ARS 4.5.2



Hopefully, this is a quick question- We have been having issues with Indexed Fields, specifically after permissions are changed (very tricky problem). I was trying to find a way to locate all of our Indexed fields to have a list of fields (which would help in quickly locating the problem in the future) and as well, determine if we really do need those indexed (I inherited the Admin position a while ago and have been in perpetual cleanup ever since). I looked in the Admin Tools, specifically the Analyze, but couldn't find anything for the Indexes. I also checked the Form Properties, however, this only lists Fields that were indexed through the Form Properties, and not Fields that were Indexed through the Field Properties /Database tab.



Does anyone know how to quickly and easily locate all Indexed fields in a given system?



Thanks SOO much in advance!!!

Shawn

This posting was submitted via the Web interface

This posting was submitted via the Web interface

Using TOAD (or SQLPlus if you have to) you can query the table
SCHEMAINDEX to get a list of all defined indexes in the system.

Select i.SCHEMAID, a.NAME, i.LISTINDEX, i.NUMFIELDS, i.UNIQUEFLAG,
i.INDEXNAME,
i.F1, i.F2, i.F3, i.F4, i.F5, i.F6, i.F7, i.F8, i.F9, i.F10, i.F11,
i.F12, i.F13, i.F14, i.F15, i.F16
>From SCHEMAINDEX i, ARSCHEMA a
Where a.SCHEMAID = i.SCHEMAID

Fred


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Shawn Stonequist
Sent: Wednesday, December 29, 2004 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Finding Remedy 4.5.2 Indexed Fields


**
Oracle 8i or 9i (we are in the process of upgrading and I don't
reemmber if our DBA has gotten to our remedy db yet)

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Frank Caruso
Sent: Wednesday, December 29, 2004 9:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Finding Remedy 4.5.2 Indexed Fields


** What database are you using?

Shawn Stonequist wrote on 12/29/2004, 10:34 AM:




Hey Listers!!!



Happy (insert desired greeting here)!!



ARS 4.5.2



Hopefully, this is a quick question- We have been having
issues with Indexed Fields, specifically after permissions are changed
(very tricky problem). I was trying to find a way to locate all of our
Indexed fields to have a list of fields (which would help in quickly
locating the problem in the future) and as well, determine if we really
do need those indexed (I inherited the Admin position a while ago and
have been in perpetual cleanup ever since). I looked in the Admin Tools,
specifically the Analyze, but couldn't find anything for the Indexes. I
also checked the Form Properties, however, this only lists Fields that
were indexed through the Form Properties, and not Fields that were
Indexed through the Field Properties /Database tab.



Does anyone know how to quickly and easily locate all
Indexed fields in a given system?



Thanks SOO much in advance!!!

Shawn




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

On Wed, 29 Dec 2004 10:11:52 -0600, Shawn Stonequist wrote:

> ARS 4.5.2
>
> Hopefully, this is a quick question- We have been having issues with
>Indexed Fields, specifically after permissions are changed (very tricky
>problem). I was trying to find a way to locate all of our Indexed fields to
>have a list of fields (which would help in quickly locating the problem in
>the future) and as well, determine if we really do need those indexed (I
>inherited the Admin position a while ago and have been in perpetual cleanup
>ever since). I looked in the Admin Tools, specifically the Analyze, but
>couldn't find anything for the Indexes. I also checked the Form Properties,
>however, this only lists Fields that were indexed through the Form
>Properties, and not Fields that were Indexed through the Field Properties
>/Database tab.
>
> Does anyone know how to quickly and easily locate all Indexed fields in a
>given system?

FYI I have an Qracle script (somewhere :-) ) that cross checks what
Remedy *thinks* is indexed with what Oracle *knows* is indexed and
builds any that are missing. It does happen.

--
Regards

Dave Saville


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)