I have the following SQL Server execution plan in XML or graphical format. Help me analyze it and identify any performance bottlenecks. Then, suggest specific optimizations to improve query performance, such as missing indexes, expensive operators, or join issues.

Execution Plan:

[Paste the execution plan XML or describe the operators and costs here]

Additional Info:

- SQL Query used: [Paste the actual SQL query here]

- Table statistics are up to date: [Yes/No]

- Are indexes currently present on the involved tables: [Yes/No]

- Expected number of records in each table: [Give estimates]

Your task:

- Analyze the execution plan.

- Point out costly operations (e.g., key lookups, table scans, hash joins).

- Suggest SQL query rewrites or indexing strategies.

- Indicate if any table statistics or indexes are missing.

- Recommend any SQL Server configuration improvements if applicable.