Hi, the following query takes a very short time (seconds): select node_name as "Node_________________Name", - platform_name,client_os_level as "OS-LVL", - char(client_version,2) as "VV", - char(client_release,2) as "RR", - char(client_level,2) as "LL", - domain_name,option_set, date(LASTACC_TIME) from nodes after adding "client_sublevel" the query will never end: select node_name as "Node_________________Name", - platform_name,client_os_level as "OS-LVL", - char(client_version,2) as "VV", - char(client_release,2) as "RR", - char(client_level,2) as "LL", - char(client_sublevel,2) as "SL", - domain_name,option_set, date(LASTACC_TIME) from nodes Can anybody tell me, why? (Server: good old VM 3.1.2.50) Regards, Gerhard Ginzler
