I want to appoligize up front if my assumptions are wrong and if they are then ignore this post, but I wanted to put out a word of warning in any case.

It sounds like you are possibly an application developer and not a DBA. It also sounds like the application development group may drive the database design. This is the biggest no-no in the development world.

Database design left to application developers will almost certainly have flaws and often large ones and these flaws will manifest themselves in time. Sometimes on day one when the application actually goes live but more often down the road when more users are added or more data builds up in the database.

Often application development groups will look at re-writing certain code or at new technology, when the actual problems reside in the underlying database structure and processing.

If you do not have a dedicated and qualified DBA I would suggest you bring this concern to management. If you do, congratulations and use that person wisely.

Good luck.