timing of a query

mickykt · #1 (**permalink**) 08-17-04, 01:13

Hi,

Is there a setting where we can see the timing the query takes to run,as in oracle we can "set timing on".As such is there anyway we can see the timing it takes to run the query.

Thanks
micky

pathri · #2 (**permalink**) 08-17-04, 01:44

Hi,
You can use the OS "time" command to know the time required to execute a query. eg

time dbaccess DBNAME <<eof
select * from test;
eof

Bye.

lloydnwo · #3 (**permalink**) 08-17-04, 23:38

Hi,

select current as start_time from systables where tabid=1
into temp x with no log;
select current - start_time from systables,x where tabid=1;

Internet Services

Web Development

Digital Marketing

Consumer Tech