How will a table be stored in Oracle if all possible indexes are created on it?

Question

Oracle

Prompt, how the table in Oracle will be stored if to create all possible indexes on it?

Answer 1

Same as without indexes: in tablespaces.
Can you ask a detailed question?

Answer 2

inside the tablespace specified when it was created, and it is in the datafile,
although it is considered good practice to separate the index tables into different spaces and onto different disks, I strongly advise

Answer 3

+ I join zip_zero... what is the essence of creating all kinds of indexes.
Orakl itself creates automatic indexes which are necessary to it.
The developer creates a couple more indexes to optimize the performance of queries that do not involve primary and unique constraints, such as composite primary keys or for keywords or product names, etc.
If you need a lot of indexes, maybe the logic and the ERM database model are not well developed and you need to optimize it with normalization methods.