I'm looking for some advice on OPENXML. Specifically, the performance. I am seeing very slow performance on a very small piece of XML.
Something about this is causing a Remote Scan. Any ideas on how to go about tuning it?
declare @tab_office as table (id varchar(100)) declare @doc_filter int exec sp_xml_preparedocument @doc_filter output,@office_id insert into @tab_office (id) (select office_id from Openxml(@doc_filter,'//filter') with (office_id varchar (100) 'office_id'))
' OOT9 OOT8 OOT5 '