Printable View
..
Trace the session that is running the search procedure. Post the plan and any associated wait events here, then we might be able to suggest something. Google "10046" for information on tracing.