Re: Query optimization for a table with half million rows

From: Chris <chris69_at_club-internet.fr>
Date: 1998/09/20
Message-ID: <6u3t5v$o3s$1@front1.grolier.fr>#1/1

Don't forget to use the statistics optimizer :

        set optimizer_mode=choose in your ini.ora file then you :

        analyze index <index_name> compute statistics
        analyze table <table_name> estimate statistics

Always Explain plan to see if you use the indexes

Chris.

>the number of rows in the table, then it's best to use bitmap indexes,
>which have a very good performance in such circumstances.
>
>The syntax is:
>
>
>CREATE BITMAP INDEX index_name ON table_name (column1, column2, ...);
>
Received on Sun Sep 20 1998 - 00:00:00 CDT