Re: Create index on tables that are joined?

Stick With Hair wrote:
> The IT group sent me the current execution plan of the query.
>
> 4 SELECT STATEMENT --- Est Cost 10822
> 3 HASH JOIN --- Est Cost 10822
> 1 TABLE ACCESS (FULL), ABC (ReportUser) --- Est Cost 5618
> 2 INDEX (FAST FULL SCAN), XYZ_IDXFIELDS (ReportUser) --- Est Cost
> 1525
>

That is not an execution plan.

Send them back the following:

EXPLAIN PLAN FOR
<your SQL statement here>

followed by:

SELECT * FROM TABLE(dbms_xplay.display);

Then post that.

Maybe they'll catch up to version 9.0.1 syntax too.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org