2 identical indexes but with different names - index load balancing?
694243Jul 7 2009 — edited Jul 9 2009Hello,
is it theoretically possible to have 2 indexes which differ only in their names? And make something like load balancing?
The real situation that brought me to that question is that one of my indexes is sometimes unavailable and the queries that use it are during this time too slow. So my idea is to have 2 indexes for the same purpose and when one of them is unavailable for some reason, then the other one will serve all queries.
So what do you think, is it possible, and if yes, do I have to do something more except defining the 2 indexes?
And please, don't try to advise me to check why my index is not available and so on. I really want to hear an answer to that particular question - it is interesting for me also just theoretically. Thanks in advance for any replies!
Regards