Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

2003-11-10 Thread Jaime Casanova 
you could put a view on every table that called a function?
Maybe, but how can i retrieve the select statement

_
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match

Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

2003-11-09 Thread David Busby 
Can you just use the SQL logging and read that file afterwords?

/djb

- Original Message - 
From: Jaime Casanova [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 14:59
Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs



 Hi everybody, can anyone tell me if there's a way to retrieve the select
 instruction executed from the catalogs, or maybe via some structure in a
 trigger?

 The reason is that i have some selects constructed on-the-fly (just part
of
 it) and i want to save that in a table in order to know what are the most
 used for optimizing them.

 Another reason for doing that is that i don't know all the selects in the
 program nor the page and this is an easier solution than examine all the
 code.

 thanx in advance, el_vigia

 _
 Protect your PC - get McAfee.com VirusScan Online
 http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


 ---(end of broadcast)---
 TIP 4: Don't 'kill -9' the postmaster


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

2003-11-07 Thread Jaime Casanova 
Hi everybody, can anyone tell me if there's a way to retrieve the select 
instruction executed from the catalogs, or maybe via some structure in a 
trigger?

The reason is that i have some selects constructed on-the-fly (just part of 
it) and i want to save that in a table in order to know what are the most 
used for optimizing them.

Another reason for doing that is that i don't know all the selects in the 
program nor the page and this is an easier solution than examine all the 
code.

thanx in advance, el_vigia

_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

---(end of broadcast)---
TIP 8: explain analyze is your friend