**
Hi Lars
This means that your query is not using a database index, but is performing
a table scan. Either there are no indexes on the fields A,B and Status, or
the data is not selective enough for an index to be used.
If you have, say, an index on Status, but not on A and B, try changing your
qualification to
('Status' = "Active") AND ($A$ = 'A') AND ($B$ = 'B')
which will increase the chances of an index being used. Or, if this is a
common query, try creating a compound index on fields A, B and Status (in
the order you have them in your query) which should be a more selective
index and will increase the chances of the index being used.
HTH
David Sanders
Remedy Consultant
=================
tel +44 (0)1494 468989
mobile +44 (0)7710 377761
email mailto:david.sanders@westoverconsulting.co.uk
web http://www.westoverconsulting.co.uk/
View Enterprise Service Suite - CRM Sales automation, Support and Training -
http://www.westoverconsulting.co.uk/ESS
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of
lars.j.pettersson@VATTENFALL.COM
Sent: 27 September 2002 12:49
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Q: MARS
**
Hi, can anyone give me some feedback on this issue, Master-Analyzer tells me
this: 'No subquery of an AND qualification uses an Index'
($A$ = 'A' and $B$ = 'B') AND ('Status' = Active) is my qualification.
> Med vanlig halsning / best regards,
>
> L Ars Pettersson
> Systemutvecklare Tabasco
> ARS Systems Engineer
>
> Vattenfall Data AB, Trollhattan, Sweden
>
> Phone: +46 (0) 520 - 888 35
> Mobile: +46 (0) 70 - 608 99 95
> Fax: +46 (0) 520 - 885 33
> mailto:lars.j.pettersson@vattenfall.com
>
To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@arslist.org
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org
Previous Topic
Index