2009/12/7 svanderclock <svanderclock@...>

>
>
> Hello,
>
> I have a table with around 100 index. the index are mostly like
> this
>
> CREATE DESCENDING INDEX INDEX_1_1_IDX ON BIGTABLE_1 (Field1, Field2,
> Field3, field4, field5, Field6);
> CREATE DESCENDING INDEX INDEX_1_9_IDX ON BIGTABLE_1 (Field1, Field2,
> Field3, field4, field5, Field7);
> CREATE INDEX INDEX_1_9_IDX ON BIGTABLE_1 (Field1, Field2, Field3, field4,
> field5, Field8);
> CREATE DESCENDING INDEX INDEX_1_9_IDX ON BIGTABLE_1 (Field2, Field3,
> Field1, field4, field5, Field6);
> .....
>

Hello,

could you describe what exactly you want to achieve with that
database-structure?
Maybe you can solve your issue by re-designing the database. And it will
probably be much faster and easier, too.

Regards,

Daniel Albuschat

--
eat(this); // delicious suicide


[Non-text portions of this message have been removed]