Archives of the TeradataForum

Message Posted: Mon, 17 Nov 2014 @ 13:04:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello Forum,

Whenever I am hitting DBQL tables, my queries are running into parsing state and are taking more time.

We do have PDCR and DBC data is moved daily into DBC as part of PDCR jobs.

The count of access rights table is 688,509.

DBQL Output:

     Query          Starttime              Firststeptime          Firstresptime          Totaltime     Parsercputime
     ---------------------------------------------------------------------------------------------------------------
     Other Select   11/17/2014 11:39:54    11/17/2014 11:39:54    11/17/2014 11:54:35?   0:14:41.770000      0.32

     DBQL Select    11/17/2014 08:29:40    11/17/2014 08:41:22    11/17/2014 08:41:23    0:11:43.460000     150.00
     DBQL Select    11/17/2014 08:43:15    11/17/2014 08:53:19    11/17/2014 08:53:20    0:10:05.930000     128.00
     ---------------------------------------------------------------------------------------------------------------

In the above tabular column, I see like, for all DBQL queries (even after applying all possible filters) the query is taking more time. i.e. there is a huge difference between Starttime and Firststeptime. Whereas, for other query there is no difference.

Is this coz of any workload or something wrong with query hitting DBC tables or any other issue?

Total time taken by the query is calculated by Firstreptime -? Starttime? But, Qrylog says Elapsed time as ((firstresptime - starttime) .

Please help me to understand the difference?

Also, please let me know, what could be the issue in my case for DBQL queries?

Looking forward for your inputs and for more knowledge on DBQL.

Thanks a lot in advance!

Thanks,

Sravan.

	<Prev	Next>		<<First	<Prev	Next>	Last>>