Re: DW query tuning - explain on

Mark Jamison wrote: > Hi Art, > > As I said, it is definitely a Poor Mans version, because you would > have to determine how you wanted to build the representations on your > own. You would have to build the bitmap of rowids, or some similar > binary representation, using the datatype. It is by no means a true > replacement, but with the binaryvar datatype you could build those > underlying bitmap of rowids, or other direct row pointers, on your > own, and then index them. > > Obviously it would be a tad ungainly, and you would have to know what > the column you added was meant to address, but it is certainly doable. Ahh got it now. I was thinking you were saying add a column to the exisiting table not create a bitmap index table. Could one build this into the VII interface I wonder? Art S. Kagel Oninit =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================