Here are the table definitions

Users table:

CREATE TABLE CORXPRADM.USERS(

USER_ID ...

I have taken the statistics by this statement...

Please let me know this is sufficient or not

CREATE STATISTICS transction_journa_stat

ON tp.transaction_journal (transaction_id,OTHER_CASH_DRAWER_ID,STATUS,REVERSED_BY,total_value)

WITH SAMPLE...

I have updated my statistics one hour before...

I have attached the graphical execution plan, Are you opening it in Management Studio or not

Thank you GulliMill,

There are 2016 rows in this view

First of all thank you for the information..

sys.dm_db_index_physical_stats table returns 2026 no of columns and the reason we have nvarchar data type is we need to support characters other than...

Actually we are not sure on which col we will place the clustered index, I have created a clustered index for the primary key , as per the performance engineering...

I have attached the graphical execution plan

Here is the ddl

create table TP.TRANSACTION_JOURNAL (

JOURNAL_ENTRY_ID numeric(31) ...