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