Re: Indexing optimisation
Posted by:
Julien B
Date: September 05, 2008 12:18AM
Thanks for your answer. I agree with you.
Just one more thing:
Is it a good idea to change thoses indexes:
KEY `index_test_1` (`typ`,`id_p`,`id_s`),
KEY `index_test_2` (`typ`,`id_p`),
Into:
KEY `index_test_1` (`id_s`,`id_p`,`typ`),
KEY `index_test_2` (`id_p`,`typ`),
?
And so i can also drop keys on id_s and id_p because they become suffixes of index_test_1 and index_test_2...
What do you think of this idea ?
Thanks
Julien
Subject
Views
Written By
Posted
2665
September 04, 2008 04:44AM
1617
September 04, 2008 09:42AM
Re: Indexing optimisation
1670
September 05, 2008 12:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.