Re: Problem with nightly batch job against a 1.5Gig table. Also BITMAP prob

Hi.

 Try creating an index on (player_id, date ).  It will improve your queries ( I assume that the  difference beteen 1000 queries are player_id and  date values ).
 Post what error you getting while trying to create  bitmap index.

 Good luck. Michael.

In article <3797b9ab.105477329_at_news.earthlink.net>,   netcomradeNOSPAM_at_earthlink.net Remove NOSPAM wrote:
> Hi,
>
> We have Oracle 7.3.4 running on Solaris 2.6. We have a query which is
> supposed to run a 1000 times against a table of a size 1.5GIG. Table
> is heavily fragmented (>100 fragments), the query is using no
> indexes. The query has the following structure:
>
> select count(*) from BIG_TABLE where player_id=12345 and drop_v_add=0
> and date <= certain_date;
>
> each of this queries returns more then a thousand rows
>
> Each of this queries takes forever to run (and we need 1000 of them).
> We don't have enough RAM to put the whole table into SGA, for some
> reason I am also not able to create a BITMAP INDEX on drop_V_Add
> column (even though I think I should be able to, Oracle gives a syntax
> error).
>
> I was wondering how much defragmentation of the table will have speed
> up the query, and if creating an INDEX on these 3 field will help, or
> if anybody has any better solutions.
>
> Thank you.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 24 1999 - 11:41:05 CDT