http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Afif, There is not such thing as an expensive _query_ in RavenDB. But yes, if you make a request one a day on something that isn't covered by any index, the behavior will be as you describe. Auto indexes are meant to help the common case, they can't help everywhere. In that scenario, it is the user responsibility to make sure that they will create a permanent index.http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment5http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment5Tue, 05 Mar 2013 06:15:30 GMTwhat happens when a very expensive dynamic query is fired? an automatic index will be created and after some (read: a lot) time, it will not be stale. given if the user doesn't run this query for some time (enough for raven to clean it up), and then runs this request again, wouldn't raven have to pay the cost of indexing everything again for this dynamic query?http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment4http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment4Tue, 05 Mar 2013 00:05:54 GMTDaniel, We never remove explicit indexes, only automatic ones.http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment3http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment3Mon, 04 Mar 2013 16:12:23 GMTPlease don't remove explicitly created indexes. I have a site that is very rarely used. It would mean the site stops working when RavenDB decides to "clean up".http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment2http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment2Mon, 04 Mar 2013 15:37:38 GMTIt's always nice when you can drop a half of your code just to make something better with less code :)http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment1http://ayende.com/161219/rob-s-sprint-indexes-and-the-death-of-temporary-indexes#comment1Mon, 04 Mar 2013 14:52:12 GMT