-
1. Re: how do materialized views work
rareddy Jan 29, 2016 12:37 PM (in response to prashanthi1)It should *not* issue a table scan, when it is key based access. I suggest turn on the log and see what queries are being submitted. The Log context for odata is "org.teiid.ODATA"
-
2. Re: how do materialized views work
shawkins Jan 29, 2016 1:11 PM (in response to rareddy)There are a couple things here that need to be decoupled to understand what is going on. It could help clarify if you seeing different behavior with and without materialization.
> it is not fetching the data if their is any duplicate entry for the column which is the primary key, even though 'Data1' is unique row.
Do you mean that you are not getting an entity back when one is expected? Again start with eliminating materialization from the picture, then once we can ensure that you are getting expected behavior you can re-introduce it.
-
3. Re: how do materialized views work
prashanthi1 Feb 1, 2016 5:53 AM (in response to rareddy)@Ramesh, I have checked the command log. i see 'finalRowCount=6840' and the query is is having (g0.id = g1.id) and ORDER_BY clauses.
-
4. Re: how do materialized views work
shawkins Feb 1, 2016 8:20 AM (in response to prashanthi1)The first query to the materialized view will perform a full snapshot load of the materialization table. Is that the expected row count for the entire view?