Results 1 to 2 of 2

Thread: Nested Loop joins

  1. 01-26-2006, 11:27 AM #1
    dattak
    dattak is offline Registered User
    Join Date
    Jan 2006
    Posts
    2

    Nested Loop joins

    Hi,

    I have came across a situation -
    When there are no indices on the tables and if we force SQL server to use the "Nested Loop" joins, the query becomes very slow. Since there are no indices then Nested loop join should not be used.

    The background for this problem is -
    Analysis services is sending some query to SQL server while doing the cube processing. SQL server is using Nested loop joins even though there are no indices on any of the tables. Is there any way by which we can force the SQL server/Analysis services not to use Nested loop joins since there are no indices in any of the tables.

    regards,
    datta.
    Reply With Quote Reply With Quote
  2. 01-26-2006, 12:26 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check response in sql2k forum.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules