i want to use this query in sybase sql but i dont find any way of running this query.
can any body tell me that what is the replacement of with clause in sybase.
i.e how to write the query similar to the query given above which run on sybase & have same execution style.
also i want to know how can we do the intersection on 2 tables in sybase sql.
i.e i want to know the substitute of "with clause" & "intersect operator" in sybase sql.
i didnt got the time to create an example for my question
but i just want to know that is sybase does not support the with clause .
& is the use of derived tables will effect the way of execution of query.
mean while m stuck with another problems.
i have database of arround 90gb i have some queries which i have runned on sql server , & on db2 . these queries never took more than 10-20 min in these databases . but now when i m running these queries on sybase they are taking more than 2 hrs & then also not completing(still running & also not giving any error) .
i have sybase 15.5 developer edition .
also one thing i found strange is that when i runned these queries on sybase with not created statistics on database tables then they took reasonable time to finish(i.e they got finished within 30 min always) but after creating the statistics they are not even finishing after 2 hrs & more.
what could be the problem now & how can i resolve this problem