>>Ron,
>>You don't need that View at all!!!!
>>It has no WHERE clause, just open you table solidwaste!fac_mas with table/Row buffering in the same alias as view.
>
>and ordered :)
Just put an index there :-)
I just don't get it. That view buffers whole table and I am almost certain that not ALL records are used from it ;-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
