Q:Object query (nested tables?) vs query on normalized tables

Hi:

I have been looking at the documentation on defining types, objects, nested tables, etc. in Oracle 8i and have a basic question on the topic as a NB. Some of these things look very interesting, like points, lines, etc. But how does the query speed stack up? For example, if I wanted a list of people and all of their credit card transactions for a month (or several months) and wanted to do queries like "show all the people, and the transactions who spent more than $200 on clothes in the month of december". Would I be better off using something like nested tables (performance-wise) or breaking out the credit card transactions into a separate table with a foreign key back to the user table? What are the pros and cons of each method?

Thanks,

   Mike Received on Tue Jan 09 2001 - 00:38:41 CST