Hi Gang,

I have just logged an enhancement to Ingres.

=============================================

In an enterprise class database, objects such as tables, indices,
procedures & rules may be frequently used or never used more than
once.

This enhancement request is for a mechanism which will permit reports
of how many times in a given class of objects, an individual object
has been used since the last restart of Ingres.

This will enable the removal of redundant objects and the refinement
of very frequently used objects

=============================================

If you think that this request has merit then please can you raise
your own Category 4 Support Issue referencing Issue 145234?

The more interest seen by Ingres Corp., the more likely it is that it
will be implemented in the near future.

Cheers,

Richard

rthdavid wrote:

If nothing else, I'd like to be able to track how frequently a
secondary index is actually used to satisfy a SELECT, UPDATE or DELETE.
My intuition is that (in general) a large fraction of indices are
useless overhead.

Of course knowing how frequently an index is used is not the only
measure of its usefulness. It may be used seasonally or for one
specific very important query. Still, usage statistics would be a
start.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Put the date in your diary today.

Hi Roy,

I trust that you will be raising an Issue iwith Ingres Corp. in
support of the Enhancement Request?

Regards,

RIchard

rthdavid wrote:

I'll try to get around to that, yes.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Put the date in your diary today.

A last-used date-time would also be useful .

Robert

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of rthdavid
Sent: Wednesday, 23 June 2010 9:54 p.m.
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Enhancement request to track object usage in Ingres

Hi Gang,

I have just logged an enhancement to Ingres.

=============================================

In an enterprise class database, objects such as tables, indices, procedures & rules may be frequently used or never used more than once.

This enhancement request is for a mechanism which will permit reports of how many times in a given class of objects, an individual object has been used since the last restart of Ingres.

This will enable the removal of redundant objects and the refinement of very frequently used objects

=============================================

If you think that this request has merit then please can you raise your own Category 4 Support Issue referencing Issue 145234?

The more interest seen by Ingres Corp., the more likely it is that it will be implemented in the near future.

Cheers,

Richard
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres
Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged. If you are not the intended recipient please delete the message and notify the sender at Ports of Auckland Limited. Any use, disclosure, copying, distribution or retention of this communication is strictly prohibited.

Hi All,

This sounds like a case for IMA. Given that we already have access to a lot of cache stats all we really need is a list of db_id, relowner, reltid, reltidx, and dates (seconds since epoch should be sufficient).

Marty Bowes

-----Original Message-----
From: Robert Allely [mailto:AllelyR (AT) poal (DOT) co.nz]
Sent: 15 July 2010 22:13
To: 'Ingres and related product discussion forum'
Subject: Re: [Info-Ingres] Enhancement request to track object usage in Ingres

A last-used date-time would also be useful .

Robert

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of rthdavid
Sent: Wednesday, 23 June 2010 9:54 p.m.
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Enhancement request to track object usage in Ingres

Hi Gang,

I have just logged an enhancement to Ingres.

=============================================

In an enterprise class database, objects such as tables, indices, procedures & rules may be frequently used or never used more than once.

This enhancement request is for a mechanism which will permit reports of how many times in a given class of objects, an individual object has been used since the last restart of Ingres.

This will enable the removal of redundant objects and the refinement of very frequently used objects

=============================================

If you think that this request has merit then please can you raise your own Category 4 Support Issue referencing Issue 145234?

The more interest seen by Ingres Corp., the more likely it is that it will be implemented in the near future.

Cheers,

Richard
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres
Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged. If you are not the intended recipient please delete the message and notify the sender at Ports of Auckland Limited. Any use, disclosure, copying, distribution or retention of this communication is strictly prohibited.


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres