Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Views and performance in Sybase....

Status
Not open for further replies.

icecore

IS-IT--Management
May 1, 2004
17
US
I'd like to know what the performance impact is to placing views over tables in sybase... we have created a dimensional schema and we are thinking of putting views over each table; how will this affect performance?? is there any drawbacks to placing a view over every table in the database... especially if it is a dimensional model (star schema)?

this database is used specifically for reporting and is a dimensional model.

any input from those who have detailed experience with views would be helpful.

thx
Peter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top