Latest Answer: Only 3 triggers can be created on a table. i.e (Insert,Update & Delete)and Maximum of 1024 columns can be created in a table. ...
Latest Answer: select count(*) from ; ...
Latest Answer: clustered index - the index order matches the order of physically stored data.cluster index can be used on table that doent get changes frequentlyusing DML statement on cluster index column have perfomance issues since it has to update the index ...
Latest Answer: The Table is called a Heap.... ...
Latest Answer: Denormalization is the process of attempting to optimize the performance of a DB by adding redundant data or by grouping data. The recommendation is always to use this for teh logical design ...
Latest Answer: sp_helpindex works for SQL server 2005 ...
How could i delete the distinct name from the table. the rest record would be available as it is in the table?
How to tune the following sql in order that the performance improve the query is SELECT DISTINCTA.BUSINESS_UNIT,A.CUST_ID,A.ASOF_DTFROM PS_ITEM_ACTIVITY A WHERE A.BUSINESS_UNIT = '1100G'AND A.ITEM LIKE 'OA%' AND A.PO_LINE = 0AND A.ENTRY_REASON 'CLEAR'AND A.ASOF_DT > '01-JAN-1900'AND A.USER1 = ' 'UNIONSELECT DISTINCTA.BUSINESS_UNIT,A.CUST_ID,A.ASOF_DTFROM PS_PENDING_ITEM A WHERE A.BUSINESS_UNIT = '1100G'AND A.ITEM LIKE 'OA%' AND
How do you subtract two columns in oracle database, two columns are in data format.Example : inserttime column senttime column?
It is also mentioned that column aliases cannot be used in the WHERE clause, then how did this query worked :"select * from (select rownum rnum,a.* from testsal a) where rnum=3;".
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
