1

What to do to get data in 0 sec on a table that keeps increasing every day. I know creating indexes would improve the select speed I don't want to create index which will in future slow down the insert/update speed.

Is there anything else we can do to improve the select performance.

For example: Simple query like

Select Count(id) from data

takes 4 sec

enter image description here

Update: As requested here is the Execution Plan

enter image description here

John VM
  • 106
  • 15
  • 1
    Well if you don't want to add an index, then I would suggest a bigger machine with a RAM drive – John Cappelletti Jun 28 '16 at 13:35
  • You need to review the Execution Plan used by Sql Server during execution. That will tell you if you can optimize the query or do index tuning. Without sharing that there is not much else the community can do for you. – Igor Jun 28 '16 at 14:03
  • Added execution plan. – John VM Jun 28 '16 at 14:25

1 Answers1

2

Assuming that you ID column have an index.

for "Select Count(id) from data" on 4 sec by 1722000 records is good speed, is not a problem.

You have a problem when queries with any clause are slow, then you need to use index to "some" fields

Anibal Díaz
  • 111
  • 7