Home » RDBMS Server » Server Administration » FASTER QUERY
FASTER QUERY [message #372820] Mon, 12 March 2001 03:52 Go to next message
Uday
Messages: 21
Registered: December 2000
Junior Member
dear all

tell me I am useing three tables a,b,c
all three tables are indexed properly.
in following query which will be faster and why?
1.select * from a,b,c
where a=b
and
a=c
and
c=b
2.select * from a,b,c
where a=b
and
b=c
and
a=c

thanks
uday

Report message to a moderator

Re: FASTER QUERY [message #372823 is a reply to message #372820] Mon, 12 March 2001 05:59 Go to previous message
Marcus Fernando
Messages: 34
Registered: September 2000
Member
You better use:

select * from a,b,c
where a=b and b=c;

If a=b and b=c then a=c.

Report message to a moderator

Previous Topic: A select statement; need some help
Next Topic: updating a variable with a field value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 29 23:50:22 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.