LTQ, DTQ, GRPBY, NLJOIN in Optimizer Plan?

MarkhamDBA · #1 (**permalink**) 03-05-09, 15:07

What do LTQ, DTQ, GRPBY, NLJOIN in Optimizer Plan of explain stand for?

Thanks

n_i · #2 (**permalink**) 03-05-09, 16:21

They are all explained in the DB2 Information Centre - all you need is search for them.

ARWinner · #3 (**permalink**) 03-05-09, 16:22

MarkhamDBA · #4 (**permalink**) 03-09-09, 09:18

thanks.

And what is LTQ and DTQ (they are not there)?

ARWinner · #5 (**permalink**) 03-09-09, 09:33

Quote:

Originally Posted by MarkhamDBA

thanks.

And what is LTQ and DTQ (they are not there)?

Try using the search to locate them from the starting point I gave you.

Andy

MarkhamDBA · #6 (**permalink**) 03-09-09, 13:17

Quote:

Originally Posted by ARWinner

Try using the search to locate them from the starting point I gave you.

Andy

got it. Thank you

I could not find them before because I was looking in InfoCentre for DB2 v8 (we are using DB2 v8.2 yet).