How do I make an update query run faster? When I saw the explain plan, it was doing a ful table scan.

What are the options? Please explain as this is urgent.

Thanks.