I was said that application is running slow so i need to make sure from the database point that it is working fine.
When I check the fragmentation of index in all the table it is fragmented by 80% or higher. But when I see the execution plan of some of the query used by the application there is always index seek . Some of tables have 5 million rows and some has couple of hundreds of thousands .
So, my question is Is it possible to use index seek by the execution plan even though the index fragmentation is more than 80%. In such situation do I need to rebuild the indexes.
I haven't seen my maintenance plan for the index in the database in our system.
Could it possible that because of the index fragmentation the application is being slow.
Thanks in advance