syssqexplain queries

A while back these queries were posted to c.d.i in response to a question I had about performance. I'm guessing at the meaning of the results, and I'd like to confirm that I understand the queries correctly. ---- select avg(sqx_estcost), count(*) num, sqx_sqlstatement from syssqexplain group by 3 order by 1 desc; Are we looking for average cost for a query that ran multiple times? ---- select * from syssqexplain where sqx_seqscan = 1 orsqx_tempfile = 1 or sqx_autoindex = 1 or sqx_srtscan = 1 order by sqx_estcost desc; I know what some of these values are, but.... sqx_seqscan=1 the query used a sequential scan sqx_tempfile=1 the query generated a temp table? (and we didn't tell it to) sqx_autoindex=1 the query built it's own temporary index? sql_srtscan=1 no idea. What's the problem with this value? Can anyone increase my understanding on these? DT -- Dave Thacker Senior Systems Administrator Omni Hotels Reservation Center V:402-952-6535 F:402-334-8013 M: 402-981-4613 (24/7)