[EMAIL PROTECTED] wrote: > Hi, > > With Explain ... I can determine the number of pages needed > for the query?
The EXPLAIN-result tells you the number of expected (but possibly wrong because of old upd stat - values, because of other distribution of data than expected, because of ...) I/O, logical I/O, not physical. At least if joins, subqueries or the like are involved, pages are 'written' and 'read' intermediately, are thrown away if not needed any more and so on. Therefore this number will not tell you the number of really needed temporary pages at any point in time during handling this query. It is a value fpr the estimated 'cost' of that query. > Can I capture this before the query is run, using a sql call > through jdbc? As the EXPLAIN-result itself is a resultset, you can handle it as every resultset. But see above and please pay attention to the fact, that PAGECOUNT is defined as CHAR(10). Elke SAP Labs Berlin > > Cheers, > > David > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
