total result comes to 159752 records , wired thing is i can run the same query in a second but another user who is a developer its taking for 3...

just curious to know.. if am using temp tables in the query does it reside in RAM and so the query may be slow when comapred to physical tables.

It is the 1st columns in couple indexes and the rest it is either 2nd or 3rd column with in the indexes.

I dont think they had any reason to put...

Grant

I think your point make sense to me but would like to know about how it works.

As you said we do have a column " Cdate " which is there...

Lynn

what is DTA?

i still get this error

As i have union all from 2 tables, i thout of creating to seperate view for each table with indexes and join them in 3rd view but when creating indexed...

I have UNION ALL in my view so i think i cant create an index on that view as it has UNION in it. any other suggestions.

thanks

Yes, there is a big view in which it queries 2 large tables and ofcourse this column does nto have any index it has to use the availabe best index...

I tried trigger on a table so that it inserts null into invalid date fields but unfortunately the trigger is not working after insert. I have only 1 way now..to...

I do have a derived column but i can not update with null at that point may be i have to add script component to check

IF isdate( mydate)=False then...

Any advise on creating a trigger or adding a component in the pkg?

The min memory setting is always 0 by default do i need to change that to work better.

If it is 0 does ti mean there no min value? what if...

Dave Ballantyne

I understand READ UNCOMITTED is exceptional as it gives inconsitent result but i think we dont worry about it as we do not update our productions so i think...

as i said most of the time we only do SELECTS on the databases and...