Can you insert a index into database of laserfiche without affecting integrity?
I hope that they can help me
Regards
Modifying the SQL db used by the LF Repository is not something we would support.
Ray's right that it's not supported, but on the other hand indexes don't change the way a table behaves they just change the performance profile of queries and modifications. What index are you thinking of adding and why? Is it something that a profiler has suggested?
Becase my database is very expensive and my query runs very slow, it takes 3 minutes to send a response.
Index on Table propval, field str_val asc.
My DBA suggested the index.
Is this a new repository? The following indexes should exist on the propval table, but if it's not new, maybe they got lost in one of the upgrades.
create index propval_num_val_ix on propval (num_val, prop_id, tocid)
create index propval_date_val_ix on propval (date_val, prop_id, tocid)
create index propval_short_str_val_ix on propval (short_str_val, prop_id, tocid)
-- Create index on the str_val if the server is sql2k5 or above and is not express edition
if cast(SERVERPROPERTY('edition') as nvarchar) not like 'Express%'
and cast(left(cast(SERVERPROPERTY('productversion') as nvarchar),
charindex('.', cast(SERVERPROPERTY('productversion') as nvarchar)) - 1) as int) >= 9
EXECUTE sp_executesql N'create index propval_str_val_ix on propval (prop_id, tocid) include (str_val)'
GO
Thx for the info but my DBA say that if We can add other index without generate problem
in the next picture is an example