I have a query(ex: below) for which I want to get the statistics like how many rows it results, what is the size of a row. SELECT t1.c1 ,t1.c2 FROM t1 WHERE NOT (t1.c1 IS NULL ); Is there any way to get it? I tried "explain extended" as below, which is not printing the details that I want. Explain Extended SELECT t1.c1 ,t1.c2 FROM t1 WHERE NOT (t1.c1 IS NULL ); Any help is appreciated. ... View more