Technical Note: [Accelops KB] What is the best way to handle table joins for data queries?

There are two ways you could join tables to create data queries for your visualization. One way would be to have the table join as part of your Postgres query, but this consumes a lot of resources and can cause poor performance. AccelOps recommends that you query from joins that have already been created in the schema. AccelOps Visual Analytics ships with two joins, ph_incident_view and ph_ec_auth_view.