Re: No primary keys
Posted in 2001
Topics: General Discussion
In article <3a5e9a26@news.iprimus.com.au>, "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > Mark Townsend wrote in message ... > >Maybe, but not necessarily if you are running a loyalty programme based on > >nbr of visits > > > sounds like a single count attribute for the single row... > > Depends on how many multiple visits you expect. It might not be worth making your fact row size bigger... Sent via Deja.com http://www.deja.com/
William Rice wrote in message <93n22c$aa6$1@nnrp1.deja.com>... >In article <3a5e9a26@news.iprimus.com.au>, > "Andrew Hamm" <ahamm@sanderson.net.au> wrote: >> >> sounds like a single count attribute for the single row... >> >> > >Depends on how many multiple visits you expect. It might not be worth >making your fact row size bigger... > Everyone KNOWS coffee drinkers will be back more than once ;-)
In article <3a6277b1@news.iprimus.com.au>, "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > William Rice wrote in message <93n22c$aa6$1@nnrp1.deja.com>... > >In article <3a5e9a26@news.iprimus.com.au>, > > "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > >> > >> sounds like a single count attribute for the single row... > >> > >> > > > >Depends on how many multiple visits you expect. It might not be worth > >making your fact row size bigger... > > > > Everyone KNOWS coffee drinkers will be back more than once ;-) > > All this talk of coffee made me go get some... Here I am trying to kick my habit, and _someone_ has to come along and remind me of coffee. Will Sent via Deja.com http://www.deja.com/