Quote:
Originally Posted by mishaalsy
it is a query having join . tableaccess .
may i have any sample query which is based on this very table . tbldocument.
your longest and most hectic one .
|
usually, I have SELECT statement, and my criteria is over docNo,docSubject,Docdate.And this table usually join on docId,docOrganizationId,docOwnerDepartmentId,docPe rsonnelId
Quote:
Originally Posted by mishaalsy
and why is the index (docid asc ) is ASC .. what is the logic behind sorting asc
why it is not desc
why it have to be asc or desc . ( force seek)
|
docId`s data type is uniqueidentifier , so does ASC or DESC make any difference ?