Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webgoon
Starting Member
5 Posts |
 Posted - 2004-02-02 : 17:20:14
|
| I have a table containing roughly 160,000 records with 120 columns. Any suggestions on how I can speed up my queries? I tried indexing, but didn't help. Reason why I have so many columns is because it is downloading data from an external source. |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-02-02 : 17:33:27
|
| Can you post the DDL? |
 |
|
|
webgoon
Starting Member
5 Posts |
Posted - 2004-02-02 : 17:35:40
|
| Sorry, I am new to this forumn, what's the DDL? |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-02-02 : 17:36:36
|
| DDL stand for Data Definition language. It defines the structure of the table. |
|
|
|
webgoon
Starting Member
5 Posts |
Posted - 2004-02-02 : 17:39:48
|
| It's actually a duplicate copy of a table located ie from the AS/400 that stores data like sales, transactions, labor, sales date, etc. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-02-03 : 05:55:24
|
| That's a 'userfriendly' description of the table....what we're looking for is something along the lines of what was used to CREATE the table on SQL...example....CREATE TABLE [dbo].[Branch] ([Code] [char] (4) NOT NULL , [Name] [varchar] (20) NOT NULL , [LastDownload] [datetime] NOT NULLON [PRIMARY]ALTER TABLE [dbo].[Branch]ADD CONSTRAINT [PK_Branch]PRIMARY KEY NONCLUSTERED ([Code])WITH FILLFACTOR = 90ON [PRIMARY]This tell me I've a table with 3 columns, and 1 'nonclustered' index.We need the equivalent for your SQL table...(NOT the AS/400 side) |
|
|
|
|
|
|
Increase performance on SELECT statement