Not to say that used to performance better than sqlanywhere? How can appear this kind of circumstance? On the same computer.

CodePudding user response:

Essentially a very not is reflected on the retrieval performance, reflect on the complex SQL, simple SQL may also is inferior to other databases

CodePudding user response:

reference 1st floor lzp_lrp response:

used to reflect on the retrieval performance is very not, reflect on the complex SQL, simple SQL may also is inferior to other database

Oh, the original so.

CodePudding user response:

Build the index, to go

CodePudding user response:

Every time is not the same! The next time is fast

CodePudding user response:

reference qweasd2002 reply: 3/f

build index, line

The same index

CodePudding user response:

reference 4 floor jlwei888 response:

every time is not the same! Next time is fast

Try N times.

CodePudding user response:

Create optimization under · · · · · ·

CodePudding user response:

This shows that SQL server is sometimes also is not necessarily the best