Four Basic Method of accessing Data:

When ever you run a plan of a query , it will give you following Four Data access method :

1. Full Table Scan

2. Full Index Scan

3.  Index Range Scan

4. Index Unique Unique Scan 

Union and Union All

UNION ALL in PSQUERY

Today I had an issue with Union all in Expense system and than I came across that UNION all can be used in PSQUERY ( some time I hate PSQUERY) . I checked few blogs over net and came across some solutions :

1. Add a new column in the query which has a unique vale most of the time Line record line number ( JRNL LN) has a unique value .

2. Some one told me to use ROWID filed if #1 is not possible than use ROW ID , it will return unique values in union. but this will not work when u will try to use join in tables ..

I bet for first approach .. It always motivate me to check XML publisher .. and few days back was planning to develop a TOOL whihc will help to run SQL in production and pull data in excel sheet ( its marriage between Tech guy and Business ) but now I am buzy in some crap work for approval .. hope I will do it by this year...