Monday, November 06, 2006

SQL Views with an ID column

I was recently given the task of replacing a table with a view and this table had an id column. There is a way to represent this id column in a view.

The following article explains the way to handle it:

Keep in mind the limitations of this approach. Your row count can't be that large. If you have a large set of data and can use snapshots, consider using a temp table filled periodically for reporting. This will improve your query size and enable additional indexes if you require them.

Happy Coding!

No comments:

Post a Comment