Sql Server2012 select article 1000 before the data quickly, but opened before 200 data is slow, to 1 minutes to open, where is the problem?

CodePudding user response:

Send a specific SQL, the table size, index column, too,
Put the two query execution plan is better,

CodePudding user response:

The execution plan directly.
Both the query execution plan posted, like the following:

CodePudding user response:

Sql queries are soon, is in the right - & gt; Editor before 200 when slow, editor if stuck,

CodePudding user response:

List the amount of data is small

CodePudding user response:

reference liaohao0101 reply: 3/f

Sql queries are soon, is in the right - & gt; Edit before 200 when slow, editor seems stuck,

This is not a real problem,
The graphical interface is not necessary, MySql, Oracle, etc all have no Sql Server so good graphical interface (SSMS),
Even under Linux is not provided, the command line mode completely,

You said the data volume is not large, specific have how old? Thousands, tens of thousands of lines?
Is not only the number of rows and columns, and each column is data type, such as: text, nvarchar (Max) and so on, these memory consumption is very large,