Posting from the Informix-list

Hello, I have a table fragmented accross 4 dbspaces. When i do a simple select using a where clause on an indexed column or any column for that matter, it is qualified as a pd query. Should this be the case?? OPTCOMPIND 0 # To hint the optimizer MAX_PDQPRIORITY 20 # Maximum allowed pdqpriority DS_MAX_QUERIES 5 # Maximum number of decision support queries DS_TOTAL_MEMORY 40960 # Decision support memory (Kbytes)

if you don't like it, just set pdq priority to 0 before issuing the query. Nona >Subject: Posting from the Informix-list >From: "Bantilan, Artemius Ian" I_Bantilan@islacom.com.ph >Date: 10.07.00 04:53 W. Europe Daylight Time >Message-id: <8kbf5g$91e$1@news.xmission.com> > > >Hello, > > I have a table fragmented accross 4 dbspaces. When i do a simple select >using a where clause on an indexed column or any column for that matter, it >is qualified >as a pd query. Should this be the case?? > >OPTCOMPIND 0 # To hint the optimizer >MAX_PDQPRIORITY 20 # Maximum allowed pdqpriority >DS_MAX_QUERIES 5 # Maximum number of decision support queries > >DS_TOTAL_MEMORY 40960 # Decision support memory (Kbytes)> > > > > > > > > >