Actually the rows for the two tables that it is doing the full table scan is 974 (not as many as I thought) and 804404 (about what I figured). Just to shed a bit of light on the size of the tables.
Thanks
Hi first thread on this site. I actually am new to Sybase, coming from an Oracle environment. I'm working in BusinessObjects and have a query that may have a performance problem. Taking 7mins for 4500 rows. There are a couple of aggregate functions creating a group by, if that helps. I did...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.