Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Slow pervasive query
I really dont have any knowledge about pervasive database. We have one simple query which is running very slow (taking ages). I have created index on HiReqe (patientid,reqnum, reqdate), patient (patientid, patsex, patcob,patdob) and hitest (reqnum, testcode). Is there anything that i can do run...- EasyBoy2
- Thread
- Replies: 0
- Forum: Pervasive: Pervasive.SQL
-
Insert into second table from first table
I am totally new to Teradata. I need help with SQL table syntax for creating, inserting table from other table I do have one requirement. 1) Create one table called : Employee contains Emp_ID, First_Name, Last_Name etc.. 2) Create second table called: Sales - Emp_ID, Sales_amout, Date etc...- EasyBoy2
- Thread
- Replies: 0
- Forum: NCR: Teradata
