Tool to tell me of unused queries in DB

Repent · #1 (**permalink**) 10-13-11, 10:49

Is there a tool that will look through my DB and tell me of queries that are not being used anywhere in the DB?

loquin · #2 (**permalink**) 10-13-11, 13:18

What DB?
what client?

in all the db servers I've used, queries are stored externally, outside the purview of the server, and are used by client applications.

And, in applications like Access, which is itself a client gui application/programming environment, and which is PC based, there is no inherent means of tracking/tracing object usage.

Repent · #3 (**permalink**) 10-13-11, 13:23

Microsoft Access 2010. I have a DB with many queries. Not sure they are all being used anymore. Some may have been changed and the original query is now no longer being used anywhere within the DB.

Internet Services

Web Development

Digital Marketing

Consumer Tech