thanks for the response -

have gone through updating first

stats (right click - properties on each item in Statistics and clicking on the "Update statistics for these columns" check box and clicking OK)

and second rebuilding indexes (right click - rebuild)

.... unfortunately no change still taking a long time for the query