Re: Choosing Primary key DBSpace

CREATE TABLE customer ( ... ) FRAGMENT BY EXPRESSION last_name >= "A", last_name <= "L" in dbs1, last_name > "L" in dbs2; One strong benefit of using expression based fragmentation is fragmentation elimination when selecting. Basically, the optimizer can eliminate all non-qualifying fragments from the search. There is a slight performance degradation during inserts though, although if you are dealing with large quantities of data, then the degradation is a mute point. With large quantities of data, expression based fragmentation can be critical. Cheers, Bryan Hughes Healtheon ==================================== Everyone has a photographic memory! Some just forgot to load the film ==================================== bryan@healtheon.com Miles Palmer wrote in message <01bdfd30$3aafa8d0$a70225a6@mpalmer>... >Is there a way to choose which DBspace the primary key of a table gets >loaded to? > >I am doing a CREATE TABLE.......FRAGMENT AS ROUND ROBIN..... > > >since it is a fairly large table.