We’re having some strange performance issues when querying alpha columns. Even if it is key field it is much slower than when comparing numeric data. The below table illustrates what we’re seeing. I realise you’ll be unfamiliar with the schema but was trying to show introducing an alpha query to the WHERE clause really slows things down. The OrderNo is the Primary Key for the table.
Is there anything that can be done to address this? Either in the configuration or recommendation in the way we query Relativity?
|
Query |
Execution Time (Seconds) |
|
select orderno from [CCSI_CCSIFW].[ccsifw]..opheader where orderno = 'A300001'
|
20 |
|
select orderno from [CCSI_CCSIFW].[ccsifw]..opheader where BillTo = 5393 and shipTo = 5394 and SalesmanNo = 25 and orderdate = 20140805 and completedate = 20150225 and totdolordered = 2295 |
3 |
|
select orderno from [CCSI_CCSIFW].[ccsifw]..opheader where BillTo = 5393 and shipTo = 5394 and SalesmanNo = 25 and orderdate = 20140805 and completedate = 20150225 and totdolordered = 2295 and orderno = 'A300001' |
21 |
