Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Worktables??

Status
Not open for further replies.
tozer9

tozer9

IS-IT--Management
May 19, 2005
2
US
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 an explain plan and it seems that Sybase creates worktables, but for two of these worktables it is doing a full table scan on some pretty hefty tables for "REFORMATTING". Not sure what that is all about. I do know that I'm joining two tables that are not invoking an index. However an index was added and to no avail the query is still taking a long time. Can anyone add any insight to this, I know that performance issues are tough to troubleshoot via forums but I wondered if it could be a result of the full table scans creating these Worktables in the explain plan.
Thanks in advance.
Joel
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top