Hi,
I've a question about amount of indices.
I explain my issue based on an example:
Table which contains person information, one row per person.
There will be lots of SELECTS doing search by special criteria,
e.g.: Age, Gender.
Now there will be 4 User groups which will
Patric wrote:
My Question now is: Is it wise to do so, and create hundreds or maybe
thousands of Indices
which partition the table for the selections.
No, this is not helpful -- basically what you are doing is taking the
first level (the first couple of levels maybe) of the index out
Alvaro Herrera [EMAIL PROTECTED] writes:
Patric wrote:
My Question now is: Is it wise to do so, and create hundreds or maybe
thousands of Indices
which partition the table for the selections.
No, this is not helpful -- basically what you are doing is taking the
first level (the first