Re: How many is too many

From: Pavel <ocp.pauler_at_gmail.com>
Date: Mon, 15 Aug 2011 11:17:32 +0400
Message-ID: <CADS+fahZ6jmE_5jXLcOSCztm_hKrERO9yznfYMGPBWf4Pd5PMA_at_mail.gmail.com>

Hi
Could you please tell me what system have 70000 tables?(retail or something else?)

Regards,
 Pavel.

2011/8/12 Ram Raman <veeeraman_at_gmail.com>

> Toon
>
> You are correct. There are about 70,000 tables owned by the application
> schema. I see one Primary key (not sure how it got there :)) and one unique
> key constraint owned by that user with no foreign key at all.
>
>
>
> On Fri, Aug 12, 2011 at 12:23 AM, Toon Koppelaars <
> toon.koppelaars_at_rulegen.com> wrote:
>
>> Tables with that many indexes, to me, are usually a strong sign that the
>> table holds multiple 'entity types', and in fact should have been designed
>> as multiple tables. I bet that there are a lot of NULL-able columns in that
>> table too, right?
>>
>> The fact that you mention 'third party product', by the way, is a sign in
>> that direction too :-)
>>
>>
>>
>> On Thu, Aug 11, 2011 at 10:45 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>>
>>> Listers,
>>>
>>> I am looking at a table in our system and it has 12 indexes, we are
>>> planning on adding another one. I am aware of the effects of having too many
>>> indexes, but in this case adding an extra index helps a certain query that
>>> runs slow. Other queries and most other operations against the table
>>> are acceptable too. I see a few tables like this; is there a number above
>>> which is considered a no-no when it comes to adding more indexes.
>>>
>>> PS. The tables and queries are structured in a way that seem to require
>>> several indexes - it is a third party product.
>>>
>>> TIA,
>>> Ram.
>>>
>>
>>
>>
>> --
>> Toon Koppelaars
>> RuleGen BV
>> Toon.Koppelaars_at_RuleGen.com
>> www.RuleGen.com <http://www.rulegen.com/>
>> TheHelsinkiDeclaration.blogspot.com<http://thehelsinkideclaration.blogspot.com/>
>>
>> (co)Author: "Applied Mathematics for Database Professionals"
>> www.rulegen.com/am4dp-backcover-text
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 15 2011 - 02:17:32 CDT