The optimization process and recommendations:

1. Avoid Calling Functions With Indexed Columns (query line: 27): When a function is used directly on an indexed column, the database's optimizer won’t be able to use the index. For example, if the column `Date_Resolved` is indexed, the index won’t be used as it’s wrapped with the function `IsDate`. If you can’t find an alternative condition that won’t use a function call, a possible solution is to store the required value in a new indexed column.
2. Avoid Calling Functions With Indexed Columns (query line: 45): When a function is used directly on an indexed column, the database's optimizer won’t be able to use the index. For example, if the column `Date_Resolved` is indexed, the index won’t be used as it’s wrapped with the function `IsDate`. If you can’t find an alternative condition that won’t use a function call, a possible solution is to store the required value in a new indexed column.
3. Avoid Selecting Unnecessary Columns (query line: 2): Avoid selecting all columns with the '*' wildcard, unless you intend to use them all. Selecting redundant columns may result in unnecessary performance degradation.

The optimized query:

SELECT
        * 
    FROM
        Report 
    WHERE
        (
            (
                Report.Create_Date BETWEEN '10/10/2013 16:00:00' AND '10/16/2013 15:59:59'
            ) 
            OR (
                Report.Date_Resolved BETWEEN '10/10/2013 16:00:00' AND '10/16/2013 15:59:59'
            ) 
            OR (
                (
                    (
                        Report.Create_Date < '10/10/2013 16:00:00'
                    ) 
                    AND (
                        Report.Date_Resolved > '10/10/2013 16:00:00'
                    )
                ) 
                OR (
                    (
                        Report.Create_Date < '10/10/2013 16:00:00'
                    ) 
                    AND (
                        IsDate(Report.Date_Resolved) IS NULL
                    )
                )
            ) 
            OR (
                (
                    (
                        Report.Create_Date < '10/16/2013 15:59:59'
                    ) 
                    AND (
                        Report.Date_Resolved > '10/16/2013 15:59:59'
                    )
                ) 
                OR (
                    (
                        Report.Create_Date < '10/16/2013 15:59:59'
                    ) 
                    AND (
                        IsDate(Report.Date_Resolved) IS NULL
                    )
                )
            )
        )