Query optimization for huge tables

Question

Query optimization for huge tables

dhaval.joshi.dj

Mr or Mrs. 500

Points: 540
More actions
November 19, 2010 at 4:28 am

#388268

Hi All,
I need help on optimizing query runtime.
I am using huge tables around 90 lacs,5 lacs, etc records table.
I have tried all indexes , etc normal stuff to optimize.
Please guide me on this..
awaiting for your reply.
Regards,
Dhaval J

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

To avoid guesswork and to get the best advice you will need to post the table stucture, some sample data and a few examples of the queries that are performing badly ideally with the actual execution plan

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Optimising big tables is about the same as small tables, just a little less forgiving

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dhaval.joshi.dj Mr or Mrs. 500 Points: 540 More actions · Answer 3

Hi ,

As per your requirement the tables which i am using has so many fields, but the join on which fields i m doing, and thats the only which i can apply join.

common fields are as below:

Table 1 - Company No, Item No (43,000 records)

Table 2 - Company no., Facility no, Item No, Order No,Work Center No (90 Lacs Records)

Table 3- Company No, Facility No, Order No (2 Lacs Records)

Table 4- Company No,Facility No, Work Center No(1500 records)

I've Applied all proper joins on all tables.

Can u plz help me on this?

Thanks,

Dhaval J

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dhaval.joshi.dj Mr or Mrs. 500 Points: 540 More actions · Answer 5

Hi,

I am not using this Sql Server.

I am just preparing Query in Crystal SQL Designer.

and as a database I am using DB2.

I hope you don't require more details and provide me solution.

Thanks,

Dhaval J

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

dhaval.joshi.dj (11/21/2010)
and as a database I am using DB2.

This is a Microsoft SQL Server forum, not a DB2 forum. We're all familiar with SQL Server here. If you have a DB2 problem, I suggest you ask it on a DB2 forum where you will find people familiar with DB2. May I suggest http://www.dbforums.com

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass