Re: Bitmap indexes - clarification

Hi,
Is it possible to see your create index statement (may be that gives a few clues )

vjoshi_at_pinnacle.co.uk

In article <359894B3.6BE713A0_at_microware.demon.co.uk>,   ij_at_microware.demon.co.uk wrote:
>
> Hi all,
>
> I have a couple of largish tables that need to be indexed on columns
> with very low cardinality. Sounds like a job for Bitmap Indexes.
>
> Ok, then. I've scoured Dejanews and read everything there that I can
> find, I've spent several hours following links from Altavista and I've
> trawled my way through the manuals. Could someone please help clarify a
> few points.
>
> I get the good old 00901 error when I try and create my indexes. Now
> I've seen lots of replies to posts on that message and lots of FAQs. So
> far I've only managed to get more confused as I go. I am running 7.3.3
> on an NT4 box with a single CPU.
>
> One thing in common with everything I've read is that <compatible =
> 7.3.2.0.0> (or better) must be set. As I am running 7.3.3 should that be
> in there?
>
> After that it all goes to pot. Some posts say that the parallel query
> option must be set, others say it isn't necessary. Which is correct?
>
> Another problem is how to set it if it is necessary. So far I've seen:
>
> event = "10111 trace name context forever"
> event = "10112 trace name context forever"
> event = "10224 trace name context forever"
>
> as being the advised way to do it and I've seen:
>
> PARALLEL_MIN_SERVERS
> PARALLEL_MAX_SERVERS
> etc.
>
> as being correct. Which is right? If it's the second way then do I enter
> '1' for both values. I realise that it's processes not actual processors
> for parallel queries (or so several of the posts said) but it all seems
> a bit grey.
>
> Apologies if I seem a bit thick but things appear to be a little vague.
> Any assistance will be much appreciated.
>
> TIA
>
> --
> ************************************************************
> Ian Jennings
> Microware Data Services
>
> This post is made entirely from recycled ones and noughts
> ************************************************************
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 10:07:57 CDT