Re: Select performance vs. mssql

От: Harald Lau (Sector-X)
Тема: Re: Select performance vs. mssql
Дата: ,
Msg-id: 005b01c5603d$7163bac0$6602a8c0@spock.nostromo
(см: обсуждение, исходный текст)
Ответ на: Re: Select performance vs. mssql  (mark durrant)
Список: pgsql-performance

Скрыть дерево обсуждения

Select performance vs. mssql  (mark durrant, )
 Re: Select performance vs. mssql  (Christopher Kings-Lynne, )
 Re: Select performance vs. mssql  (mark durrant, )
  Re: Select performance vs. mssql  (Neil Conway, )
  Re: Select performance vs. mssql  ("Harald Lau (Sector-X)", )
 Re: Select performance vs. mssql  (mark durrant, )
  Re: Select performance vs. mssql  (Bruno Wolff III, )
   Re: Select performance vs. mssql  (Alex Turner, )
   Re: Select performance vs. mssql  (Enrico Weigelt, )
    Re: Select performance vs. mssql  (Jochem van Dieten, )
  Re: Select performance vs. mssql  (Christopher Kings-Lynne, )
   Re: Select performance vs. mssql  ("Jim C. Nasby", )
 Re: Select performance vs. mssql  (mark durrant, )
  Re: Select performance vs. mssql  (Josh Berkus, )
   Re: Select performance vs. mssql  (PFC, )
   Re: Select performance vs. mssql  (Michael Stone, )
    Re: Select performance vs. mssql  (John A Meinel, )

Mark,

> MSSQL Machine:
> That "Explain Analyze" command doesn't work for MSSQL,

try this:
set showplan_all on
go
select ...
go

Harald


В списке pgsql-performance по дате сообщения:

От: "Harald Lau (Sector-X)"
Дата:
Сообщение: Re: Select performance vs. mssql
От: mark durrant
Дата:
Сообщение: Re: Select performance vs. mssql