Hi,
Anyone who knows the definition of database view?
and what is database view used for?
I'll appreciate it if someone answer my question.
thanks a lot.
Discussion posts and replies are publicly visible
super short: it is a "view" of specific wanted values of two or more DB tables joined by common attributes. Example: Table "Office" with columnsId, office name, addressId, employeeCount,...table "address" with columnsId, post code, city, street, house numberyou can join then via office.addressId - adress.id fields so a "unique conneciton" is possinle.your view CAN have the following columns then: OfficeId, officeName, post code, city, street, house number
mad by an join SQL statement https://www.w3schools.com/sql/sql_join.asp
used in Appian context: performance improvements (DB joins are faster), more smaller tables instead of view big tables with redundant data but with view they can be connected easily.