Paul Thomas пишет:
Hello and thanks for the comment. Yes. I did analyze.
On 29/04/2004 09:53 Anton Nikiforov wrote:
looks like after a few tests that i've done i'm confused more than before.
I did create a table and inserted 200000 random records of two different types of data into it.
Did you analyze the table afterwards?
Also thanks to Bruno Wolff III for his comments, i have found it easyear to use his suggestion.
But while i was making my tests i found a way how to use partial or complex indexes, but they make my selects slower than without indexes at all :( (I was selecting * not a ma()). But i'll continue my tests.
-- Best regads, Anton Nikiforov
smime.p7s
Description: S/MIME Cryptographic Signature
