locked
Why I always got the timeout error? RRS feed

  • Question

  • Hi, all experts here,

     

    Thank you very much for your kind attention.

     

    I encountered a problem which occured when I tried to create a view cross join a fact table with over 4 million records with other 6 dimension tables filtered by specific condition which restricts the whole results returned to be only serveral hundred rows. But why I always got the timeout error saying timeout expired prior to the completion of the execution.

     

    Is it because cross joins between too many tables which confused the database engine? Should I alternatively join whatever two tabels first and then use the result (the single table returned) to join other table and so on?

     

    Why is that and how can I figure it out? Thank you very much in advance and I am looking forward to hearing from you shortly for your kind advices and help.

     

    With best regards,

     

    Yours sincerely,

     

    Tuesday, June 26, 2007 10:32 AM