Keeping Result Table
From: Doug Anderson <dganderso_at_figmnt.tayloru.edu>
Date: 1995/08/04
Message-ID: <1995Aug4.104459.2232_at_figmnt.tayloru.edu>#1/1
Date: 1995/08/04
Message-ID: <1995Aug4.104459.2232_at_figmnt.tayloru.edu>#1/1
Question: How do you keep a result table around for further queries without
using snapshots? I don't want to have to install the distributed
option just to have the functionality of snapshots.
Also, is there a better way to do the following? I wish to show the average
number of rows per block for a given table. This is all that I could come
up with...
CREATE VIEW TMPVIEW
from &tablename
SELECT AVG(ZORK)
AS select count(*) ZORK
group by substr(rowid,1,8);
FROM TMPVIEW;
DROP VIEW TMPVIEW;
- Doug (DBA) Anderson at Taylor Univ. - DGANDERSO_at_TAYLORU.EDU