Subject | Increase the max context number |
---|---|
Author | cybervegeta2000 |
Post date | 2007-04-13T19:13:31Z |
I'm trying to execute a view which use more than 255 contexts. Because
of this, the view can't be executed. Is it possible to increase that
number? Or anyone can suggest me a work arround for this? I tried
to convert my views to selectable stored procedures, in order to don't
reach the contexts limit. But it caused another problem: the stored
procedures aren't using my indexes, so the queries takes much much
much time to be executed.
of this, the view can't be executed. Is it possible to increase that
number? Or anyone can suggest me a work arround for this? I tried
to convert my views to selectable stored procedures, in order to don't
reach the contexts limit. But it caused another problem: the stored
procedures aren't using my indexes, so the queries takes much much
much time to be executed.