I'm creating a wiki-style website with a mysql database.
I'm not to this point yet, but I'm thinking ahead of when I'll
need to start populating the database. Obviously the point
is for users to populate it themselves, but I've been to
several travel wiki websites and it seems like they almost
share identical information. Is there some sort of central
data I could tap into? Or just wishful thinking?...
xhermit
Last Activity: Dec 20 '07, 01:01 PM
Joined: Mar 22 '07
Location:
-
Populating wiki database
-
For the FT Table the only index is SA_ID. For the SA table there is SA_ID and SA_STATUS_FLG. I've changed the optimizer hint to RULE and it sped things up in dev, but not in production. Tried a few others but none helped. Not sure how to get around the group by, since I'm using SUM. Here's also something weird I discovered:
If I do
select a.sa_id from sa a; // it will do an index fast full scan, runs quickly
... -
Here's the explain plan
[HTML]
Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop
SELECT STATEMENT Optimizer Mode=CHOOSE 36 K 79513
FILTER
SORT GROUP BY 36 K 2 M 79513
TABLE ACCESS BY INDEX ROWID SYSADM.FT 29 464 2
NESTED LOOPS...Leave a comment:
-
I'm pretty sure it doesn't have unlimited resources. As for tkprof, that's something I don't have permissions to. The criteria in the where claus don't have much room to change, they're all required for the query.Leave a comment:
-
SQL Optimization
This query is taking over 6 minutes to run, and is doing a full table scan. The only indexes are SA_ID for both tables. Both tables have millions of records. Unfortunately I'm a programmer, not a DBA so I don't have privelages to use all the optimizing tools.. and I have to jump through some hoops to get indexes created. Is that the only solution in this case?
SELECT A.ACCT_ID, A.SA_TYPE_CD, B.SA_ID, SUM( B.CUR_AMT), A.SA_STATUS_FLG ,...
No activity results to display
Leave a comment: