Archives of the TeradataForum

Message Posted: Tue, 27 Sep 2005 @ 14:27:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Rishi,

You're welcome. Congratulations on sticking close to 3NF, it'll pay dividends down the road. But, be sure to put enough effort into building a presentation layer to insulate your users from having to navigate the complexities.

I did highlight paying close attention to the relationship tables earlier, choosing the primary and secondary indices is very important here. You need to find an indexing strategy that supports queries from both directions, from Event to Account as well as from Account to Event for example. You may find that using the same PI as one of the 2 tables will help out, by co-locating the relationship rows with the rows of the most frequently used entity. I would also recommend using a PPI for the Event table, assuming that you're at a release that permits them.

Good luck, let us know how it goes.

JL

	<Prev	Next>		<<First	<Prev	Next>	Last>>