SQL and Indexes

Thread View: borland.public.kylix.database.sqlservers

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by peter Wed, 19 Mar 2003 06:35

#147

Author: peter
Date: Wed, 19 Mar 2003 06:35

13 lines
1398 bytes

Hi

I am curious ... is there any way of forcing a Select statement to 
explicity us an index.... or does the optimizer simply control the 
choice of a valid index to use (assuming more than one index has been 
defined).

Also/Or does the order of the Selected items or the order in the where 
clause control the appropriate index to use???

Thanks in advance

PM

Re: SQL and Indexes

#148

Author: Lukasz Rzanek
Date: Thu, 20 Mar 2003 10:13

14 lines
1713 bytes

In article <3E780FC8.8030304@neways.com.au>, peter wrote:
> I am curious ... is there any way of forcing a Select statement to 
> explicity us an index.... or does the optimizer simply control the 
> choice of a valid index to use (assuming more than one index has been 
> defined).
There is a PLAN statement you can use, but not in all servers.
But most of the servers will try to 'guess' which index will be best
suited for queries...

-- 
Lukasz Rzanek - konsultant @ BSC Polska oraz admin @ news.borland.pl
Ty te� mo�esz pokaza� co� ciekawego, zarejestruj si�
http://www.borland.pl/seminaria/bdd2003/signin.shtml
BDD 2003 - Nowe! Ekscytuj�ce! .NET Windows Linux Java i wi�cej

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads