Sorry about posting in the wrong forum! I will make sure the post is in the appropriate forum next time.

I've attached the ExecutionPlan.sqlplan with the reply.

Thank you!

This is the execution plan after I modify the view with decimal conversion on the activity id.

However, a simple view query still took about 2 minutes to execute in...

I'm using 2005 and have attached the execution plan with my reply.

Again....I really appreciate your immediate response! 🙂

Correction on the index on transmission_log_detail table..

Non-Unique, Non-cluster INDEX

a. [transmission_log_id]

b. [activity_id] --> this is the same as journal_id in Journal table

Thanks for you reply!! Especially during the holiday season! 🙂

Here are the table schema and details for each table

1. Jounral - 2,248,196 rows

CREATE TABLE [dbo].[journal](

[journal_id] [decimal](18, 0) IDENTITY(1,1) NOT NULL,

[safe_id]...