2) Support of Views and Views on Views
Yes
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
for my case I kill the process after two hours of waiting. Another one strange
example
insert into temp.temp_table (id, field1)
select id,field1 from view where id=1
Was killed after some hours of waiting too. I asked some questions about
complex views in this forum and I didn't get any answers.
I think using of complex views is a bad idea. So MaxDB has very limited support of views.
I tested MaxDB 7.6.00.10 and 7.6.00.14 (18.07.2005).
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
