| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Views and indexes
Hi,
I have two views that are being joined. Both these views contain a union
all in them.
The base tables of the view have an index against them. The where clause of
the select against the joined views uses these columns. However, I do not
believe that it does indeed use the indexes when joining the views. Am I
correct in this thought process?
kimberly.smith_at_eds.com
From: "Wilmont Belfry" <AlphaLeader_at_1stconnect.com>
Date: Mon, 1 May 2000 18:08:09 -0400
Subject: [Off Topic....]
Oh these poor boy's . . . . What will they do . . . .
http://www.idg.net/go.cgi?id=256143
{} Wilmont C. Belfry, Platform Specialist
{} Eastern Michigan University - 127 Pray-Harrold Hall
{} Ypsilanti, Michigan 48197 - 734.487.4384 - Fax: 734.481.9290
{}
{} All I got is a red guitar, three notes and the truth.
{} All I got is a red guitar, the rest is up to you....
{}
{} ---- Bob Dylan
From: "Patricia Clarke" <pclarke_at_mach2.wlu.ca>
Date: Mon, 1 May 2000 18:19:58 -0400
Subject: Spooling SQL*Plus output to a unique file name (Unix)
Oracle 7.3.4, Dynix 4.2.3, SQL*Plus 3.3.4, PL/SQL 2.3.4
I have a PL/SQL script that I am running on the server (Unix) and I am spooling the output into a log file. The problem is that I don't want to lose the previous output each time I run the script, so I want to be able to either spool to a unique file name each time (e.g. by appending a timestamp or the process ID or something to the log file name), or keep the same file name but *append* the new output to the old instead of overwriting everything each time.
I have read the SQL*Plus documentation on the SPOOL command and don't see any options for appending output to an existing file instead of overwriting, Received on Mon May 01 2000 - 17:01:18 CDT
 |
 |