Query optimization
From: Mark <i_at_dontgetlotsofspamanymore.invalid>
Date: Fri, 10 Jan 2014 13:14:23 +0000
Message-ID: <d9svc9htpv6k2mniepdfhp08jgmk7o25k6_at_4ax.com>
[Quoted] [Quoted] I have a question about index usage in table queries. We need to do fast queries on new tables. Therefore the standard method of generating table statistics does not work. We have verified that Oracle is not using the indexes.
Date: Fri, 10 Jan 2014 13:14:23 +0000
Message-ID: <d9svc9htpv6k2mniepdfhp08jgmk7o25k6_at_4ax.com>
[Quoted] [Quoted] I have a question about index usage in table queries. We need to do fast queries on new tables. Therefore the standard method of generating table statistics does not work. We have verified that Oracle is not using the indexes.
Assuming that the tables are less than 1 day old and have 1-2Mio records/hour written to them what is the best way to achieve this?
An added complication is that the tables are referred to by synonyms as the user has no way to predict the actual table name.
--
(\__/) M.
(='.'=) If a man stands in a forest and no woman is around
(")_(") is he still wrong?
Received on Fri Jan 10 2014 - 14:14:23 CET