06-20-2012 04:01 AM
Bellow discussion has little to do with InfoMaps.
Well, views might be slower, but in many cases, the user doesn't experience any difference.
it depends on what the view does. Any ordering, summarization and joining will obviously make the view slower than a corresponding table.
If the source tables to the view have indexed columns, it's not sure that the view can merge the where-clauses in the view with a where clause from the calling program (in this case, the Infomap).
06-29-2012 02:51 AM
Yes. you can create Infomap using different different source tables. like 1) Stored Process 2) Dataset and can be done in 9.1 version also.
If you are creating views, you cant filter the data as of my knowledge.