cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Query send warning full scan

jgronau
Contributor

when i start a query (Select [Anwendung] Where [Kurzer Name] Like "#mega#") everytime a warning popup(...full scan... will show. How can i stopp this warning popup ?

 

 

5 Replies

JDH
Super Contributor

In our case this warning was related to unnamed objects.

Merci Jerome,

is there a generel solution ? Maybe a option or parameter 

 

Jens

You need to add a condition

Example 

 

Select [Library] Where And [Short Name] Like "#test#" -> full scan warning

 

With condition

Select [Library] Where [Parent Library] Null And [Short Name] Like "#test#" -> no full scan warning

Jerome

Merci Jhorber,

how can i filter the list of objects 

 

 

jhorber
MEGA
MEGA

There is not option to disable this warning.

 

As you may have understood, it reports that the query execution requires to evaluate (scan) all the objets for certain objects types .

Sometimes this is not appropriate and you can filter the list of objects evaluated. It is likely that the warning will not be displayed.

Sometimes this is appropriate for your need and the warning will be displayed

 

 

Jerome