Alexey Gaidukov wrote:
MaxDB works well only with simple views. If a view contains union or
outer join or grouping then it's complex view. It's possible to use
comples views only with very small tables or in some very simple
cases. For example 'view' it is a complex view, 'id' is a primary key
of one of the table from 'view'.
select id,field1 from view where id=1
has good plan and works very fast. A little bit more complex example
select id,field1 from view where id=1 and UDF(id)=true
Searching a normal table with udf(id) will take ages as well, because
table scans take a long time. To say that MaxDB has "limited support" of
views because of this is harsh.
If you need this, MaxDB supports function indices for tables, but I
don't know if they are used with views. Queries on views of multiple
views can be extremely fast if you are selecting on indexed/primary keys.
/J
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
