RE: Formatting of listserv messages

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Sat, 02 Feb 2002 09:42:24 -0800
Message-ID: <F001.004042E7.20020202094020@fatcity.com>

It looked fine with MS lookout .. :)

-----Original Message-----
Sent: Saturday, February 02, 2002 10:50 AM To: Multiple recipients of list ORACLE-L

Naveen and others,

Does this email appear to be completely unformatted to anyone else?

Just wondering if it was formatted when sent, or if this happened along the way, or is it just me?

I'm not likely to respond to something this difficult to read, and I'm just wondering if there's a remedy to this.

I've noticed at times that I may send a carefully formatted post only to have it appear rather messy on the list. This most often happens to email I send from work using Lotus Notes.

Here at home I use KDE Kmail, which is much easier to configure than Lotus.

Sorry for the intrusion, but this appeared to be an interesting topic, and it's rather tedious to format these so I can read them. I can't be the only one that recieves mail looking like this.

Thanks,

Jared

On Saturday 02 February 2002 02:50, Naveen Nahata wrote:
> Type ----------------------------- -------- ----------------- CDL_CDL_ID

> NOT NULL NUMBER(10) DESCRIPTION NOT NULL
> VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2)
DATE_RECEIVED
> NOT NULL DATE DATE_RETURNED DATE
> INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE

> NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30)
> LAST_CHANGE_DATE NOT NULL DATEDESCRIPTION column will have
> relatively few distinct values compared to the number of rows so a Bitmap
> Index will be considered.Following are the 3 queries which immediately
come
> to my mind ...Query 1:SELECT DISTINCT cdl.description FROM cdl_documents
> cdl WHERE description NOT IN (SELECT description
FROM
> cdl_documents WHERE cdl_cdl_id = 5);Query 2:SELECT
DISTINCT
> cdl.description FROM cdl_documents cdl WHERE NOT EXISTS (SELECT 1

> FROM cdl_documents WHERE cdl_cdl_id = 5

AND                       cdl.description =

> description);Query 3:SELECT DISTINCT description FROM
> cdl_documentsMINUSSELECT DISTINCT description FROM cdl_documents WHERE
> cdl_cdl_id = 5;One more thing -It is generally not advisable to use a NOT
> IN or NOT EQUAL TO clause for an indexed column bcoz the optimizer will go
> for FULL TABLE SCAN rather than INDEX SCAN. But what if i have a Bitmap
> Index? Will an INDEX SCAN still be avoided? If yes, why?Regards, Naveen
>
>
> ---------------------------------
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Feb 02 2002 - 11:42:24 CST