I'm facing an issue with one of the query after recreated indexes on database. Issue was, results are getting in flash time once after recreated the indexes. Whenever new data coming into the tables i.e after recreated being done dates, data is taking long
time than normal(3) hours.
I have changed the forum, any where thanks for quick reply.
Yes i'm executed the plan one of the table( query contained view which has created on table) taking 90% cost for look up. I'm giving the same parameter values in input before recreating indexes and after.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.