Comes over unformated for me and I generally don't even try to read
things like that as with completely html messages - I just don't have
the time.
Pat
>
>
> 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
> >
> >
> > ---------------------------------
> > Do You Yahoo!?
> > Yahoo! Auctions Great stuff seeking new owners! Bid now!
>
> ----------------------------------------
> Content-Type: text/html; charset="us-ascii"; name="Attachment: 1"
> Content-Transfer-Encoding: 7bit
> Content-Description:
> ----------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Hildebrand
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
