SQL server partitions

deyakhatib · June 15th, 2004, 08:27 AM

Hi all,

I created 3 tables with constraints on numeric field and I created a union all view on these tables, when I select from the view specifying a condition using the constraint field the execution plan scans all the tables instead of the table that match the condition.

regards,

happygv · June 15th, 2004, 06:29 PM

Can you post the code that you used to create the view?

Cheers!

_________________________
-Vijay G

Strive for Perfection

deyakhatib · June 16th, 2004, 03:41 AM

Hi,
the code I used is:
"Create View View1
As
SELECT * from t1
UNION ALL
SELECT * from t2
UNION ALL
SELECT * from t3"

Regards,

Quote:

quote:Originally posted by happygv
Can you post the code that you used to create the view?

Cheers!

_________________________
-Vijay G

Strive for Perfection

bmains · June 16th, 2004, 11:51 AM

Hello,

Instead of using *, try listing out the criteria. That may or may not solve your problem. If not, at least there is a performance gain with that.

Brian

happygv · June 16th, 2004, 02:12 PM

What is the SELECT statement that you used to query from this VIEW?

Can you post that please?

_________________________
-Vijay G

Strive for Perfection

deyakhatib · June 17th, 2004, 01:14 AM

Hi All,
I solved the problem guys.
thanx for ur help

Quote:

quote:Originally posted by happygv
What is the SELECT statement that you used to query from this VIEW?

Can you post that please?

_________________________
-Vijay G

Strive for Perfection

happygv · June 17th, 2004, 02:07 PM

If you wish, can you post on how you solved it?

Cheers!

_________________________
-Vijay G

Strive for Perfection