Join threads

Posted in 2005

PARAMESHWAR PATHRI — Fri, 04 Mar 2005 06:42:36 — source: IIUG Forums & Mailing Lists

Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.

↪ replying to PARAMESHWAR PATHRI

Dominic Seah Chin Teck — Fri, 04 Mar 2005 08:18:53 — source: IIUG Forums & Mailing Lists

hi, you should see some differences in running this command onstat -g mgm nobody@ace.iiug.org on 03/04/2005 02:42:40 PM To: ids@iiug.org cc: (bcc: Dominic Seah Chin Teck/MEH/SG/Parkway) Subject: Join threads [4402] Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g