Re: Forcing Pervasive Index


Steven Blank
 

Marc,

The following query returns index names and numbers for a table:

select Xe$Offset as Index_No
, Xe$Name as Index_Name
from X$File
inner join X$Field
on Xf$Id = Xe$File
where Xf$Name = 'Active_Totes'
and Xe$DataType = 255
order by Xe$Offset

where 'Active_Totes' is the name of the table of interest.

Is that what you're looking for?

Steve Blank

At 02:15 PM 7/6/2017, you wrote:
Hi,

In Pervasive SQL V11

We are looking to force an index in a query that is having performance issue with this command
"SELECT * "FROM TABLE" WITH(INDEX(hint_of_index));".

We're trying to list all the indexes of a table with
their "hint" and with the right hint complete the SQL command.

Does anyone know how to get a list of all the indexes with their "hint" of a table in "pervasive" ?

The name in XPA does not work...

Thank You very much!

Marc

Join main@magicu-l.groups.io to automatically receive all group messages.