Re: Compare Oracle to SQL Server

Dan,

For the interfacing part, check out DirectConnect from Sybase (even if you're not using a Sybase RDBMS) http://www.sybase.com/detail?id=204835

HTH,
Koen.

dmcdona3%csc.com_at_Internet
06/09/2000 05:22

To:	ORACLE-L%fatcity.com_at_Internet
cc:	 (bcc: Koen Lefever/GKBCCB)

Subject:	Compare Oracle to SQL Server

We are evaluating packages and a question of a UNIX/Oracle platform Vs. an NT/SQL Server platform is raised. Specifically we are concerned with SQL Server and if it can scale and does it have breaking points. Are interfaces from Oracle to SQL Server easy or problematic. Input is needed and references to resources are welcome.

TIA,
Dan McDonald

-- 
Author: 
  INET: dmcdona3_at_csc.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).




------------------------------

 From: "Walter K" <alden14004_at_yahoo.com>
 Date: Wed, 6 Sep 2000 08:14:54 -0500
 Subject: Analyze Indexes vs. Table

This is a multi-part message in MIME format.

------=_NextPart_000_001C_01C017DA.89B69E90
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What are the pros/cons of analyzing only the indexes of a table versus =
analyzing the table (which will also analyze the indexes)?

I'm asking this because I am using a data extraction tool that does just =
this--it only analyzes the indexes of a table rather than the table =
itself. This approach seems reasonable in theory but it appears that it =
does not produce comparable execution paths. I have found that unless I =
analyze the table, the execution path will not take advantage of a =
bitmap index for a delete operation against the table.

What are your opinions and experiences?