Um... Something must be messed up... Mine came through ok... Work email using Outlook/Exchange... I just looked at the fatcity history page for this messages and there is a bunch of tags in the message... But, it is formatted... Using IE5.5 at least...
Tim -----Original Message----- Sent: Saturday, February 02, 2002 11: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 > > > --------------------------------- > 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: Johnston, Tim 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).