I would start with looking at what indexes exist on tables
[CRALTNUMBERS]
[MATCHNAME]
[BOM]
[CRALTTITLES]
[font="Courier New"]
TableColumnOperationIndexActual RowsEst Rowsdiff
[BOM]BOMIDIndex Spool (Eager Spool)311,69790,394,96090,083,263
[CRALTNUMBERS]CREATIONIDIndex Spool (Eager Spool)147,98940,412,55840,264,569
[MATCHNAME]CREATIONIDIndex Spool (Eager Spool)811,51639,993,03639,181,520
[BOM]ITEMIDIndex Spool (Eager Spool)185,47019,798,58519,613,115
[CRALTTITLES]CREATIONIDIndex Spool (Eager Spool)155,4971,639,8011,484,304
[/font]
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day