Re: Link server very slow

From: Mike Hodgson (mwh_junk_at_hotmail.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 22:52:44 +1100

DDL = Data Definition Language. It's basically the schema of the
associated DB objects (table(s), index(es), view(s), trigger(s), etc.).

DML = Data Manipulation Language. It's the queries that you're running
against those DB objects (SELECT, INSERT, UPDATE, DELETE). The queries
about which you say the response time through the linked server is slow.

Basically, nobody can help you if you don't give any details about the
problem. To help we'll need to see things like execution plans,
indexing of search arguments, etc. We can't do that if we don't know
what your schema looks like and what query you're trying to execute
against that schema. It's possible that the entire table data is being
sent from the Oracle box to the SQL box (through the linked server) and
then any WHERE clause is being applied (which would explain the slow
performance through the link but not direct to Oracle) but we can't tell
if you don't show us the schema & queries involved.

Cheers,
Mike.

teera wrote:
> Mike
> What is DDL and DML? Please explain me more?
>
> Thanks
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:68EECFB8-4739-4277-A78A-A21F3F6CA33B@microsoft.com...
>
>>Hi
>>
>>Post the DDL and DML.
>>
>>Regards
>>Mike
>>
>>"teera" wrote:
>>
>>
>>>I created a link server to 'oracle', properties is below
>>> Server Type : Microsoft OLE DB Provider for Oracle
>>> Product name : ora
>>> Data Source : sapdbproduction
>>> Provider string : MSDAORA
>>>Compare query response time (1 record)
>>> PL-SQL : 0.5 sec
>>> SQL Query Analyzer : 1.4 minute
>>>
>>>How can i do?
>>>
>>>Thanks in adv.
>>>
>>>
>>>
>
>
> 

-- 
˙ūC

Relevant Pages

  • import to clone schema revisited
    ... Task is to clone a schema. ... tablespace references to the TS of the original exported objects. ... Various solutions found on the web involved extracting the DDL from the ... select 'spool off' from dual; ...
    (comp.databases.oracle.server)
  • Re: Problems getting a stored procedure to work
    ... Did you do that all of those SELECT/assignment statements can be ... have no DDL, so we do not know about keys or anything else. ... You did do months of careful research and design on your schema, ... Since you also did not post specs or DDL, this is a wild, ...
    (microsoft.public.sqlserver.programming)
  • Re: Range query optimization help?
    ... >constraints, Declarative Referential Integrity, datatypes, etc. in your ... >schema are. ... >I am going to guess that the problem is in the DDL; bad keys and ...
    (microsoft.public.sqlserver.programming)
  • Re: Need help importing / exporting a schema
    ... As a schema is connected to a user, ... new client who wants to run it under Oracle 10g. ... The exact format of the SQL isn't important because I ... care of that - it allows for DDL as well ...
    (comp.databases.oracle.misc)
  • Re: PyTable?
    ... A database plan ... Normally the schema is created in Python code, ... queries, for instance. ... As to BasicProperty, its purpose is to allow for defining rich ...
    (comp.lang.python)