Recreating indexes issue.

    General discussion

  • Hello Experts.

    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.

    Any particular reason behind this?

    I would be grateful for your help.



    Wednesday, October 23, 2013 3:38 PM

All replies

  • Hello JS,

    This is a forum for SSAS - Data Mining; you should post your question to a more related forum.

    Have you checked the execution plan of the query when it's slow? Are you using parameters in the query and it may could be a parameter sniffing issue?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, October 23, 2013 5:39 PM
  • Hello Olaf,

    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.

    Any help much appreciated.



    Thursday, October 24, 2013 8:33 AM